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.
11 lines
432 B
SQL
11 lines
432 B
SQL
/*16. 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 as Sean Maguire.*/
|
|
SELECT dir_fname, dir_lname, mov_title
|
|
FROM director
|
|
JOIN movie_direction
|
|
ON director.dir_id=movie_direction.dir_id
|
|
JOIN movie
|
|
ON movie_direction.mov_id=movie.mov_id
|
|
JOIN movie_cast
|
|
ON movie_cast.mov_id=movie.mov_id
|
|
WHERE role='Sean Maguire'; |