01.04 · SQL
When did each sale happen?
Accounts wants a list of bill numbers and their dates.
Return sale_id and sale_date for every sale.
Expected output (sample data)
Rows may come in any order.
| sale_id | sale_date |
|---|---|
| 1 | 2023-12-18 |
| 2 | 2023-12-23 |
| 3 | 2024-01-06 |
| 4 | 2024-01-08 |
| 5 | 2024-01-10 |
| 6 | 2024-01-13 |
| 7 | 2024-01-17 |
| 8 | 2024-01-22 |
| 9 | 2024-02-03 |
| 10 | 2024-02-05 |
| 11 | 2024-02-09 |
| 12 | 2024-02-14 |
…and 11 more rows.
Loading the SQL workspace…
Item 4 of 77 · updated 2026-10-12