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

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid