For this problem, we are using the Chinook Database again. (Remember to go the "Helpful Links" page on the course website for details about this database.)

Write a query that returns the Genres that I have purchased the most tracks of. I only care about genres that I've purchased at least 10 tracks. Please ignore any tracks costing a dollar or more (they are primarily TV shows). Please output two columns, the name of the genre ("Genre_Name") and the number of tracks purchased ("Number_Purchased"). Order from most purchases to least.

You need only need the tables: Track, Genre and Invoice Line. You may assume each row of invoice line has a quantity of 1.

Transcribed Image Text:

Artist ArtistId Name Playlist PlaylistId Name Employee EmployeeId LastName FirstName Title Reports To BirthDate HireDate Address City State Country PostalCode Phone Fax Email K k« Artist ArtistId Name Playlist PlaylistId Name Employee EmployeeId LastName FirstName Title Reports To BirthDate HireDate Address City State Country PostalCode Phone Fax Email K k«

Answer rating: 100% (QA)

Required Query SELECT genrename as GenreName countinvoicelinequantity as NumberPurchased from genre join track on trackgenreid genregenreid join invoiceline on invoicelinetrackid tracktrackid GROUP by ... View the full answer