Full GROUP BY pipeline

SELECT rep, SUM(amount) AS total
FROM sales
WHERE region = 'West'
GROUP BY rep
HAVING SUM(amount) > 300
ORDER BY total DESC;