Generate the 12 months of 2026 with a recursive CTE. For each month show month
(its first day, as a DATE) and orders: the number of orders placed in that month, 0 when
there were none.
End your query with ORDER BY month.
| orders |
|---|
| order_id (PK) |
| order_date |
Generate the 12 months of 2026 with a recursive CTE. For each month show month
(its first day, as a DATE) and orders: the number of orders placed in that month, 0 when
there were none.
End your query with ORDER BY month.
| orders |
|---|
| order_id (PK) |
| order_date |
| month | orders |
|---|---|
| 2026-01-01T00:00:00.000Z | 1 |
| 2026-02-01T00:00:00.000Z | 1 |
| 2026-03-01T00:00:00.000Z | 1 |
| 2026-04-01T00:00:00.000Z | 1 |
| 2026-05-01T00:00:00.000Z | 1 |
| 2026-06-01T00:00:00.000Z | 1 |
| 2026-07-01T00:00:00.000Z | 1 |
| 2026-08-01T00:00:00.000Z | 0 |
| 2026-09-01T00:00:00.000Z | 0 |
| 2026-10-01T00:00:00.000Z | 0 |
| 2026-11-01T00:00:00.000Z | 0 |
| 2026-12-01T00:00:00.000Z | 0 |
Run query to see output