Description

Director (d-id, fname, lname, gender)
Direct (m-id, d-id)
Actor (a-id, f_name, l_name, Salary)
Cast (m-id, a-id, role)
Sub-query
1. Find all actors from “Sholay” and “K3G”.
3. Find total number of actors casted in each movie.
4. List role of actor having salary greater than 200000.
5. List movie details directed by female director.
6. Find details of actors having maximum salary in each movie.
7. List all movie details directed by “Karan Johar” (natural join)
10. Give all actors details not casted in “Dangal” (right outer join)
11. List details of movies not staring by “Amitabh Bachchan” and actor details not casted in
“Shakunatala Devi” (emulate full outer join using union)
Join
7. List all movie details directed by “Karan Johar” (natural join)
10. Give all actors details not casted in “Dangal” (right outer join)
11. List details of movies not staring by “Amitabh Bachchan” and actor details not casted in
“Shakunatala Devi” (emulate full outer join using union)