| order_id | id | status | happened_at | rn |
|---|---|---|---|---|
| 101 | 3 | delivered | 2026-01-10 12:00:00 | 1 |
| 101 | 2 | packed | 2026-01-10 12:00:00 | 2 |
| 101 | 1 | created | 2026-01-10 10:00:00 | 3 |
| 101 | 7 | imported | 2026-01-10 09:00:00 | 4 |
| 102 | 5 | cancelled | 2026-01-10 11:00:00 | 1 |
| 102 | 4 | created | 2026-01-10 09:00:00 | 2 |
| 103 | 6 | created | 2026-01-10 08:00:00 | 1 |
| order_id | id | status | happened_at |
|---|---|---|---|
| 101 | 3 | delivered | 2026-01-10 12:00:00 |
| 102 | 5 | cancelled | 2026-01-10 11:00:00 |
| 103 | 6 | created | 2026-01-10 08:00:00 |
| order_id | MAX(id) |
|---|---|
| 101 | 7 |
| 102 | 5 |
| 103 | 6 |
Это сохранённый результат PHP CLI и MySQL на учебных данных, не интерактивная форма.