Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • What are the top 5 customers by purchase amount?

  • List all tracks purchased in 2023.

    • Follow-up question: create a pie 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).

...