HAVING Clause
The HAVING clause operates exactly as a WHERE clause, although it operates on the output of a GROUP BY.
You can use the same syntax with the HAVING clause as with the WHERE clause.
Syntax Rules
-
Expressions used in the GROUP BY clause must contain either an aggregate function (
COUNT,AVG,SUM,MIN,MAX), or be one of the grouping expressions.