Return revenue for every month of 2024 (first day of month) as month and revenue, showing 0 for months with no orders. Use a recursive CTE to build the months.
12 rows with columns month, revenue — first 3 shown:
| # | ||
|---|---|---|
| 1 | 2024-01-01 | 9941 |
| 2 | 2024-02-01 | 7392 |
| 3 | 2024-03-01 | 11689 |
Run your code to see the output here.