HAVING clause
Performs a filter operation on a SELECT query, by examining the
results of aggregation functions rather than testing each individual table row. Therefore, it is
always used in conjunction with a function such as COUNT(),
SUM(), AVG(), MIN(), or
MAX(), and typically with the GROUP BY clause also.
Restrictions:
The filter expression in the HAVING clause cannot include a scalar subquery.
