Premium customers we can call

Return the customers who are in the premium segment and have a phone on file (phone is not NULL).

Returncustomer_id· 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-05 14:15:00INfreeNULLChen Wei

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

c_0052026-05-12 16:00:00USpremiumNULLElena Garcia

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

3 rows

customer_id

c_001

c_002

c_006

If you get stuck

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows