In this repo I will be using the SQLite sample chinook database to answer hypothetical business questions, demonstrating various intermediate and complex SQL techniques that can be used to help business analysis.
The Chinook database covers data from a hypothetical record store. We will be looking to answer 3 hypothetical questions:
- Finding which genres sell best in the USA to maximise profits from advertisement.
- Analysing employee sales performance to figure out the best performing employees.
- Analysing sales data by country to find the most profitable markets, and markets with potential investment opportunity