Question
ACTOR (id, fname, lname, gender) MOVIE (id, name, year, rank) DIRECTOR (id, fname, lname) CAST (pid, mid, role) MOVIE_DIRECTOR (did, mid)
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.
Step by Step Solution
3.33 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
Answer 3 Select mid nameyearr...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started