customer spend salary by dept orders by status best sellers ▶ Run (⌘↵) SELECT c.name, c.city, COUNT(o.id) AS orders, SUM(o.total) AS spent FROM customers c LEFT JOIN orders o ON o.customer_id = c.id GROUP BY c.name, c.city ORDER BY spent DESC;
