Using an alias in ORDER BY after grouping

Question

Accepted Answer

GROUP BY customer first collapses rows: Alice = 100 + 200 = 300, Bob = 400, Carol = 150. ORDER BY total DESC then ranks the groups: 400 first, 300 second, 150 last. You can sort by an aggregate alias in ORDER BY because ORDER BY runs after both GROUP BY and SELECT.