Suggest important questions and write advanced queries for them (it is necessary
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
For This or a Similar Paper Click To Order Now
Suggest important questions and write advanced queries for them (it is necessary to make a join between the tables in each query)
Here are some models that have been put in place, but for lack of similarity, I want a distinct answer from your idea:
q1 :We want to find out the most popular music genre for each country. We determine the most popular genre as the genre with the highest amount of purchases. Write a query that returns each country along with the top generation. For countries where the maximum number of purchases is shared, return all Genres.
You will need to use the Invoice, InvoiceLine, Customer, Track, and Genre tables for this query
q2: Return all the track names that have a song length longer than the average song length. Though you could perform this with two queries. Imagine you wanted your query to update based on when new data is put in the database. Therefore, you do not want to hard code the average into your query. You only need the Track table to complete this query.
Return the Name and Milliseconds for each track. Order by the song length with the longest songs listed first.
q3:Write a query that determines the customer that has spent the most on music for each country. Write a query that returns the country along with the top customer and how much they spent. For countries where the top amount spent is shared, provide all customers who spent this amount.
You should only need to use the Customer and Invoice tables.
