-- Orders still waiting to ship, counted per customer.

-- (status is NULL until a packer claims the order)

SELECT customer_id, COUNT(*) AS waiting

FROM orders

WHERE status <> 'shipped'

GROUP BY customer_id;