You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
9 lines
357 B
SQL
9 lines
357 B
SQL
/*14. Write a query in SQL to find the name of movie and director (first and last names) who directed a movie that casted a
|
|
role for 'Eyes Wide Shut'.*/
|
|
SELECT dir_fname, dir_lname, mov_title
|
|
FROM director
|
|
NATURAL JOIN movie_direction
|
|
NATURAL JOIN movie
|
|
NATURAL JOIN movie_cast
|
|
WHERE role IS NOT NULL
|
|
AND mov_title='Eyes Wide Shut'; |