High-value fulfilled orders in a date window

Return order_id, status, amount_usd for orders that meet all of these:

status is paid or delivered
amount_usd is at least 100
placed from 15 May 2026 up to but not including 25 May 2026 (order_ts is a timestamp)

Sort by order_id.

Tables & sample data

orders

16 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

query.sql

Loading editor…