task Date series & missing days · medium
Days with no orders
From 2025-03-01 through 2025-03-14, return each day (column day, YYYY-MM-DD) on which no order was placed, earliest first.
what to return
- Columns
day- Rows
- 7 rows · in the order asked
- Watch for
- Both boundary days are included.
- Any order status counts as an order.
- Skill
- Find missing dates by building a calendar. Refresher: Ask whether a row exists →
expected result
Your query should return exactly these columns and values. Run it and compare.
expected result7 rows · in this order
| day |
|---|
| 2025-03-02 |
| 2025-03-04 |
| 2025-03-07 |
first 3 of 7 rows
data you can query
Sample rows from each table. Each column shows its type underneath; → marks a link to another table.
sales_orders5 columns · 33 rows
| idinteger · key | shopper_idinteger → shoppers | order_datetext | statustext | delivered_datetext |
|---|---|---|---|---|
| 101 | 1 | 2025-01-04 | delivered | 2025-01-08 |
| 102 | 2 | 2025-01-06 | delivered | 2025-01-07 |
| 103 | 1 | 2025-01-15 | delivered | 2025-01-20 |
| 104 | 3 | 2025-01-18 | cancelled | NULL |
| 105 | 4 | 2025-01-22 | delivered | 2025-01-31 |
showing 5 of 33 rows
solution.sql
Hints and the answer are always available. Using them counts the question as solved with help.