Customer order date range
For each order return `id`, `customer_id`, `first_order` and `latest_order`: the earliest and latest order dates for that customer. Order by customer then id.
What a strong answer looks like
Say what the query is meant to return before you write it, and name the shape of the answer: how many rows, grouped by what. Then watch the NULLs and the duplicates, because that is where most of these are lost.
Run onlyA query runs as one statement, so there is nothing to step through. Run it and read the rows.
0:00 of about 13 min
query.sql
Expected, in this order
| id | customer_id | first_order | latest_order |
|---|---|---|---|
| 1 | 1 | 2026-01-04 | 2026-03-03 |
| 2 | 1 | 2026-01-04 | 2026-03-03 |
| 7 | 1 | 2026-01-04 | 2026-03-03 |
| 3 | 2 | 2026-01-21 | 2026-02-28 |
| 4 | 2 | 2026-01-21 | 2026-02-28 |
| 6 | 2 | 2026-01-21 | 2026-02-28 |
1 more row
Your result
Run your query to compare.
1 more set of rows are waiting. Free with an account.
Run or narrate your approach, then ask the coach.