Explicit Status List
The operations report needs orders that are not paid, which in this data means pending and cancelled. Rewrite the filter as an explicit list of needed statuses and keep sorting by id.
Original query
SELECT * FROM orders WHERE status <> 'paid' ORDER BY id
Eksempel på forventet output
Sådan ser et korrekt svar ud — dets rækketal er dets eget og behøver ikke at matche skematabellerne.
| id | status | user_id | created_at |
|---|---|---|---|
| 13 | pending | 3 | 2024-02-05T14:00:00 |
| 14 | cancelled | 4 | 2024-02-06T16:00:00 |
| 15 | pending | 2 | 2024-02-07T11:00:00 |
Log ind for at se indsendelseshistorik
Log indLog ind for at bruge AI-mentor
Log ind