Active premium customers

Marketing wants to target premium customers in the US, Canada, and the United Kingdom.

Retrieve customers where segment = 'premium' and country is one of 'US', 'CA', or 'GB'.

Returncustomer_idcountrysegment· any row order

Columns

customers6 columns

columntype

customer_idVARCHAR

signup_tsTIMESTAMP WITH TIME ZONE

countryVARCHAR

segmentVARCHAR

phoneVARCHAR

full_nameVARCHAR

6 rows · 6 columns

customers6 rows

customer_idsignup_tscountrysegmentphonefull_name

c_0012026-05-01 09:00:00INpremium+91-9876543210Ananya Sharma

c_0022026-05-03 11:30:00USpremium+1-415-555-0123Brad Miller

c_0032026-05-10 08:45:00UKfree+44-20-7946-0958Dhruv Patel

c_0042026-05-15 10:20:00CApremium+1-416-555-9876Felix Beaulieu

c_0052026-05-18 13:00:00GBpremium+44-20-7946-1234George Thompson

c_0062026-05-20 10:00:00CAfree+1-604-555-0147Hannah Tremblay

3 rows

customer_idcountrysegment

c_002USpremium

c_004CApremium

c_005GBpremium

If you get stuck

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows