For each month with sales (month = first day), return the product_name with the highest revenue and that revenue (ties by product_id).
12 rows with columns month, product_name, revenue — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | 2024-09-01 00:00:00 | Smartwatch | 4999 |
| 2 | 2024-12-01 00:00:00 | Smartwatch | 4999 |
| 3 | 2024-10-01 00:00:00 | Coffee Maker | 3299 |
Run your code to see the output here.