Delivered Orders
Delivered Orders
In the "Kotomarket" marketplace all orders are stored in a flat table orders. Each order has a number, the customer's name, a city, a status, and an amount.
The status column takes the values: 'обработка' (processing), 'в пути' (in transit), 'доставлен' (delivered), 'отменён' (cancelled).
The support team wants to see only delivered orders, to collect feedback from happy customers.
Write a query that returns three columns — order_id, customer, amount — only for orders whose status equals 'доставлен'.
Use only SELECT and WHERE with an equality check. No sorting is required and row order does not matter.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| order_id | customer | amount |
|---|---|---|
| 1 | Анна Котова | 2490 |
| 3 | Мария Усова | 1500 |
| 6 | Павел Когтев | 260 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in