Exercise

Are jazz songs long?

Your manager came to you with a question; how does track length differ by genre? To answer this question, you'll want to use a subquery to join the track and genre tables. Good luck!

Instructions

100 XP

SELECT the genre_name from the subquery and find the average milliseconds for each genre.
Update the query so that records are retrieved FROM the subquery.
To successfully find the average length of each song, group the results by genre_name.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise