This is a SQL Project that analyzed the Chinook Database based on a particular criteria. It is a project submitted for the Udacity's Data Foundations Nanodegree Program. Data is based on the Chinook Database available online. Programs are written in SQL and the compiler used is DB Browser for SQLite.
- Jazz.SQL - analyzed which countries bought the most Jazz tracks
- Top10.SQL - analyzed which are the Top 10 most popular Genre, based on the tracks bought, in Germany
- Top5customers.SQL - analyzed who are the Top 5 customers (their full names) based on their invoices and total purchases and by descending order
- Trackspergenre.SQL - analyzed how many tracks are there per Genre, grouped by Genre and by descending order based on the number of Tracks per Genre.