ACTOR (id, fname, lname, gender) MOVIE (id, name, year, rank) DIRECTOR (id, fname, lname)
Question:
ACTOR (id, fname, lname, gender)
MOVIE (id, name, year, rank)
DIRECTOR (id, fname, lname)
CAST (pid, mid, role)
MOVIE_DIRECTOR (did, mid)
id column in ACTOR, MOVIE & DIRECTOR tables is a key for the respective
table.
CAST.pid refers to ACTOR.id, CAST.mid refers to MOVIE.id
MOVIE_DIRECTOR.did refers to DIRECTOR.id and MOVIE_DIRECTOR.mid
refers to MOVIE.id
1. List all the actors who acted in at least one film in 2nd half of the 19th
century and in at least one film in the 1st half of the 20th century
2. List all the directors who directed a film in a leap year
3. List all the movies that have the same year as the movie 'Shrek (2001)', but a
better rank. (Note: bigger value of rank implies a better rank)
4. List first name and last name of all the actors who played in the movie
'Officer 444 (1926)'
5. List all directors in descending order of the number of films they directed
6. a. Find the film(s) with the largest cast.
b. Find the film(s) with the smallest cast.
In both cases, also return the size of the cast.
7. Find all the actors who acted in films by at least 10 distinct directors
(i.e. actors who worked with at least 10 distinct directors).
8. Find all actors who acted only in films before 1960.
9. Find the films with more women actors than men.