Two filters, one query

SELECT customer, SUM(amount)
FROM orders
WHERE status = 'shipped'
GROUP BY customer
HAVING SUM(amount) > 100;