Problem 1 of 13 · Filtering Rows & ConditionsNext: Active premium customers

00:00

Practice / SQL / Filtering Rows & Conditions

WorkingGuided

EasyAbout 3 minFiltering Rows & ConditionsLesson: Filtering Rows & Conditions (P01) →

Filter to paid orders

Retrieve only orders with a paid status.

Returnorder_idcustomer_idamount_usd· any row order

Columns

orders5 columns

columntype

order_idVARCHAR

customer_idVARCHAR

order_tsTIMESTAMP WITH TIME ZONE

statusVARCHAR

amount_usdBIGINT

Sample table

6 rows · 5 columns

orders6 rows

order_idcustomer_idorder_tsstatusamount_usd

o_001c_0012026-05-10 10:00:00paid100

o_002c_0022026-05-12 14:20:00paid150

o_003c_0042026-05-22 12:00:00refunded50

o_004c_0022026-05-26 09:00:00delivered200

o_005c_0012026-05-27 14:00:00NULL90

o_006c_0022026-05-28 10:00:00pending60

Expected output

2 rows

order_idcustomer_idamount_usd

o_001c_001100

o_002c_002150

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows