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.
|
/*20. Write a query in SQL to list all the movies with year, genres, and name of the director.*/
|
|
SELECT mov_title, mov_year, gen_title, dir_fname, dir_lname
|
|
FROM movie
|
|
NATURAL JOIN movie_genres
|
|
NATURAL JOIN genres
|
|
NATURAL JOIN movie_direction
|
|
NATURAL JOIN director; |