Remember the key difference: WHERE filters individual rows before grouping, while HAVING filters groups after they've been created by GROUP BY. You can only use aggregate functions like COUNT(), AVG(), SUM(), etc. in the HAVING clause, not in the WHERE clause.