SQL
Chinook Database
Monthly sales for the most popular genre
Rock is the most popular genre in terms of total sales. For this genre, February is the month with the highest sales, with $96.03, and March has the lowest sales, with $41.58.
Relationship between units sold and albums released in USA
There is a positive correlation between Total Units Sold per Artist and Albums Released per Artist, with 34 units sold and 21 albums released. This artist is Iron Maiden.
Top artist earnings by country
The artist that has earned the most is Iron Maiden, $138.6. Almost a quarter of there earnings, $33.66, are being generated in USA.
Top album length for TV shows
From all the albums corresponding to TV shows, the longest one in minutes is Lost, Season 1 with a duration of 1080 minutes, and the shortest is Aquaman, with a duration of 41 minutes.
References
About the database
The information utilized in this project is a Chinook database provided by Udacity in the Business Analysis Nanodegree program. The database comprehends 11 tables.
About the queries
All queries include one or more explicit join, and one or more aggregation. All queries present WITH clauses, which are temporary relations, and written as sub-queries.