WHERE filters before grouping

Question

Accepted Answer

WHERE runs before GROUP BY. Only shipped orders survive the filter - Alice's 100 and Bob's 300. Then GROUP BY customer groups the two remaining rows, giving one sum per customer. If you need to filter on aggregate results (e.g. sum > 200), you need HAVING, not WHERE.