Users With Paid Orders

#995

Marketing is building a list of users who have at least one order with status = 'paid'. Rewrite the report without the nested list check and return unique user id values sorted by id.

Original query

SELECT u.id FROM users u WHERE u.id IN (SELECT user_id FROM orders WHERE status = 'paid') ORDER BY u.id

Oodatava väljundi näidis

Nii näeb õige vastus välja — selle ridade arv on omaette ega pea ühtima skeemi tabelitega.

id
1
2

Logi sisse, et esitada

Sinu päringu tulemus ilmub siia