📋 Challenges solved

1. Top customers by spending
   Retrieve the 5 customers who spent the most in the store.

2. Top artists by revenue
   Identify the 5 artists with the highest sales revenue.

3. Longest tracks
   List the 10 longest tracks in the catalog, including their duration in minutes.

4. Employees and their customers
   Show the Sales Support Agents and the number of customers each one manages.

5. Best-selling genre

   • Version 1: Genres with the highest number of tracks sold.
   • Version 2: Genres with the highest revenue generated.

⚙️ How to run the queries

1. Download the Chinook database in SQLite format:
   👉 Chinook_Sqlite.sqlite

2. Open it in a free online SQL editor such as:
   👉 SQLite Online

3. Load the database and run the .sql scripts from the queries/ folder.

🚀 Next steps

• Create visualizations (Power BI / Tableau) to present insights.
• Write additional queries (e.g., customers by country, sales by year).
• Expand the portfolio with more SQL projects and analytics case studies.