WHERE and HAVING
WHERE filters records before grouping, while HAVING filters the resulting groups.
4 minutes. No sign-up needed.
This lesson is part of the Data Analytics course.
Example plan3 lessons · 10 min
GROUP BY3 min
WHERE and HAVINGSQL aggregation4 min
Distinct countsSQL aggregation3 min
An example. Your plan follows your answers, so it can start later and end sooner.
Build my plan
Start free, no account needed.