Full GROUP BY pipeline

Question

Accepted Answer

Step 1 - WHERE keeps only West rows: Bob 200, Carol 900, Bob 400. Alice (East) is excluded. Step 2 - GROUP BY rep: Bob = 600, Carol = 900. Step 3 - HAVING SUM > 300: both pass. Step 4 - ORDER BY total DESC: Carol (900) before Bob (600).