GROUP BY with HAVING

SELECT

  customer_id,

  COUNT(*) AS orders,

  SUM(total) AS lifetime_value

FROM orders

WHERE status = 'shipped'

GROUP BY customer_id

HAVING SUM(total) > 1000

ORDER BY lifetime_value DESC