Flip the table: months as rows, products as columns
Same sales report, but in this projection it's more convenient to see months as rows and products as columns. For every month compute total sales separately for products A, B, and C. Show the month and three columns with the per-product sums. Sort by month.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| a | b | c | month |
|---|---|---|---|
| 100.00 | 80.00 | 60.00 | 2024-01 |
| 150.00 | 90.00 | 70.00 | 2024-02 |
| 120.00 | 110.00 | 85.00 | 2024-03 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in