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_idcustomeramount
1Анна Котова2490
3Мария Усова1500
6Павел Когтев260
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid