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.
8 lines
325 B
SQL
8 lines
325 B
SQL
/*23. Write a query in SQL to compute a report which contain the genres of those movies with their average time and number of
|
|
movies for each genres.*/
|
|
SELECT gen_title, AVG(mov_time), COUNT(gen_title)
|
|
FROM movie
|
|
NATURAL JOIN movie_genres
|
|
NATURAL JOIN genres
|
|
GROUP BY gen_title;
|
|
ORDER BY mov_dt_rel desc; |