...
What are the top 5 customers by purchase amount?
List all tracks purchased in 2023.
Follow-up question: create a chart from the top 7 tracks by revenue
What is the most purchased album in the database?
What are the top three genres with the highest revenue generated, and which artists contributed most to those revenues?
For each customer, determine the average number of days between their purchases and identify those with irregular purchasing patterns (standard deviation of days between purchases).
...