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.
Qualquer ordem de linhas
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
EntrarFocus radio
Paused · SomaFM · Fluid