Bookings per Month
Finance wants a month-by-month view of booking volume. For each calendar month with at least one booking, output the year, month, and booking count. Sort from earliest month to latest.
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.
| year | month | booking_count |
|---|---|---|
| 2020 | 3 | 4 |
| 2024 | 1 | 2 |
| 2024 | 2 | 2 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in