please if you need the data you can find it online chinook database. the query must have join and one aggregation.

Question 2: Who is writing the rock music? Now that we know that our customers love rock music, we can decide which musicians to invite to play at the concert. Let's invite the artists who have written the most rock music in our dataset. Write a query that returns the Artist name and total track count of the top 10 rock bands. You will need to use the Genre, Track, Album, and Artist tables. Check Your Solution The top 10 bands are shown below along with the number of songs each band has on record. Artistid Name Songs 1 22 Led Zeppelin 114 2 150 112 112. Artist Album Albumld Artistid Name MediaType MediaTypeld Name Title Artistid Track Trackld Name Albumid Media Typeld Genreld Composer Milliseconds Bytes UnitPrice Playlist Playlistld Name Playlist Track Playlistld Trackld Genre Genreld Name InvoiceLine InvoiceLineld Invoiceld Trackld UnitPrice Quantity Employee Employeeld Last Name FirstName Title ReportsTo Birth Date HireDate Address City State Country PostalCode Phone Fax Customer Customerld FirstName LastName Company Address City State Country PostalCode Phone Fax Email SupportRepld Invoice Invoiceld Customerld InvoiceDate BillingAddress Billing City BillingState Billing Country Billing PostalCode Total Email Question 2: Who is writing the rock music? Now that we know that our customers love rock music, we can decide which musicians to invite to play at the concert. Let's invite the artists who have written the most rock music in our dataset. Write a query that returns the Artist name and total track count of the top 10 rock bands. You will need to use the Genre, Track, Album, and Artist tables. Check Your Solution The top 10 bands are shown below along with the number of songs each band has on record. Artistid Name Songs 1 22 Led Zeppelin 114 2 150 112 112. Artist Album Albumld Artistid Name MediaType MediaTypeld Name Title Artistid Track Trackld Name Albumid Media Typeld Genreld Composer Milliseconds Bytes UnitPrice Playlist Playlistld Name Playlist Track Playlistld Trackld Genre Genreld Name InvoiceLine InvoiceLineld Invoiceld Trackld UnitPrice Quantity Employee Employeeld Last Name FirstName Title ReportsTo Birth Date HireDate Address City State Country PostalCode Phone Fax Customer Customerld FirstName LastName Company Address City State Country PostalCode Phone Fax Email SupportRepld Invoice Invoiceld Customerld InvoiceDate BillingAddress Billing City BillingState Billing Country Billing PostalCode Total Email