Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Business Statistics

Authors: Ronald M. Weiers

7th Edition

978-0538452175, 538452196, 053845217X, 2900538452198, 978-1111524081

More Books

Students also viewed these Databases questions

Question

what is the class of the IP address 1 0 . 1 . 2 . 3 / 2 4 ?

Answered: 1 week ago