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.
Any row order
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid