Fill Missing Dates With Zero Sales

Return the daily sales for every date between the first and last sale date, showing 0 for days with no sales.

Table schema

Sales(sale_date DATE, amount INT)

Sample data

sale_date | amount
2026-01-01 | 100
2026-01-01 | 50
2026-01-04 | 70