#1051

Manual Review List

Step 3: prepare a safe list of orders for manual review. Include orders with status = 'paid' that have no payment with status = 'success'. Return id and status, sorted by id.

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.

idstatus
12paid

Your query result will appear here