Orders with no captured payment

Return orders that have no captured payment — either no payment row at all, or only non-captured ones (e.g. failed). Column: order_id. Sort by order_id.

Tables & sample data

orders

11 rows total · first 5 shown

order_idvarchar	customer_idvarchar	order_tstimestamp with time zone	statusvarchar	amount_usdbigint
o_001	c_001	2026-05-10 10:00:00	paid	100
o_002	c_001	2026-05-15 11:00:00	paid	200
o_003	c_001	2026-05-20 09:30:00	paid	50
o_004	c_002	2026-05-12 14:20:00	paid	150
o_005	c_002	2026-05-25 08:15:00	paid	75

payments

9 rows total · first 5 shown

payment_idvarchar	order_idvarchar	paid_tstimestamp with time zone	amount_usdbigint	statusvarchar
pay_001	o_001	2026-05-10 10:05:00	100	captured
pay_002	o_002	2026-05-15 11:05:00	200	captured
pay_003	o_003	2026-05-20 09:35:00	50	captured
pay_004	o_004	2026-05-12 14:25:00	150	captured
pay_005	o_005	2026-05-25 08:18:00	75	failed

query.sql

Loading editor…