HAVING Clause

Eliminates group rows that do not satisfy a predicate.

Syntax

HAVING predicate [, ...]

Semantics

predicate

is the same as specified for the WHERE clause.

Notes

Each column referenced in predicate must unambiguously reference a grouping column, unless the reference appears within an aggregate function.
You can use expressions in the HAVING clause.