Customers Active in Both Halves of May

The marketing team wants to identify customers who placed orders in both halves of May 2026.

The first half covers May 1–15 and the second covers May 16–31, inclusive of every time during those dates. An order in each half is sufficient, regardless of order status. Customers who ordered only in one half should not appear.

Return each qualifying customer only once.

Ordering: Sort by customer_id in ascending order.

Returncustomer_id

Columns

orders5 columns

columntype

order_idVARCHAR

customer_idVARCHAR

order_tsTIMESTAMP WITH TIME ZONE

statusVARCHAR

amount_usdBIGINT

Sample table

16 rows · 5 columns

orders16 rows

order_idcustomer_idorder_tsstatusamount_usd

o_001c_0012026-05-10 10:00:00paid100

o_002c_0012026-05-15 11:00:00paid200

o_003c_0012026-05-20 09:30:00paid50

o_004c_0022026-05-12 14:20:00paid150

o_005c_0022026-05-25 08:15:00paid75

o_006c_0042026-05-18 16:40:00paid300

o_007c_0042026-05-22 11:50:00paid100

o_008c_0042026-05-22 12:00:00refunded50

o_009c_0022026-05-26 09:00:00delivered200

o_010c_0072026-05-24 15:00:00cancelled80

o_011c_0012026-05-27 14:00:00NULL90

o_012c_0032026-05-06 10:00:00paid60

o_013c_0052026-05-15 18:30:00paid45

o_014c_0062026-05-15 12:00:00paid120

o_015c_0052026-05-28 10:00:00paid70

o_016c_0032026-05-31 20:15:00delivered95

Expected output

4 rows

customer_id

c_001

c_002

c_003

c_005

If you get stuck

Show hint · 3 hints Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows