IntermediateWHERE & Filtering
Find orders shipped within 24 hours
The query
SQL
SELECT
order_id,
cust_id,
order_date,
shipped_at,
EXTRACT(HOUR FROM (shipped_at - order_date)) AS hours_to_ship
FROM orders
WHERE shipped_at IS NOT NULL
AND shipped_at - order_date <= INTERVAL '24 hours'
ORDER BY hours_to_ship ASC;Note
“Interval comparison between two timestamp columns. Result is an interval type.