Top 2 Customers with Highest Sales Every Month
Using the table playground.sales, Identify the top 2 customers based on their total sales for each month. Display the result based on asc order of their rank and month.
These are the tables to query for this question:
playground.sales- id int
- month string
- sales int
Your answer should include these columns:
- id integer
- month varchar
- total_sales integer
- rank integer
Querying is only for logged in users!
Write Your Query Here (you can run selections by highlighting!)
Query Results
No queries have been run yet.