SQL Queries Exercise:

Assume the following Tables:

Table: ACTOR Columns: id, first_name, last_name, gender

Table: MOVIES Columns: id, name, year, rank

Table: ROLES Columns: actor_id, movie_id Table:

DIRECTORS Columns: id, first_name, last_name

For the queries below, please use the above tables and indicate the SQL function/script:

1. Find all the actors that played in the movie Ocean's Twelve.

2. Find the time period in which each actor was active, by listing the earliest and the latest year in which the actor starred in a film.

3. Repeat the query above #2, but only list actors that have starred in at least 10 movies.

4. Find the director that has directed the largest number of movies.

5. List the director that worked with the largest number of actors.