Statuses as One List

#997

The operations filter looks for orders with status = 'paid' or status = 'pending', but the condition has grown into repeated checks of the same field. Rewrite it as one allowed-status list and return order id values in ascending order.

Original query

SELECT id FROM orders WHERE status = 'paid' OR status = 'pending' ORDER BY id

Sampla aschuir a bhfuiltear ag súil leis

Seo é an chuma a bheadh ar fhreagra ceart — tá a líon rónna féin aige, ní gá dó na táblaí scéime a mheaitseáil.

id
10
11
12

Logáil isteach chun seoladh

Beidh toradh d'iarratais le feiceáil anseo