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;
Tested against PostgreSQL 16

Note

Interval comparison between two timestamp columns. Result is an interval type.

Tables referenced