Detect Missing Months

Return every month (as 'YYYY-MM') between the first and the last month that has sales in which there were no sales at all. Order by month.

Table schema

Sales(sale_date DATE, amount INT)

Sample data

sale_date | amount
2026-01-10 | 100
2026-02-05 | 50
2026-04-20 | 70