The HAVING clause operates exactly as a WHERE clause although it operates on the output of a GROUP BY. It supports the same syntax as the WHERE clause.

Syntax Rules

  • Expressions used in the group by clause must either contain an aggregate function: COUNT, AVG, SUM, MIN, MAX, or be one of the grouping expressions.