Use a HAVING clause in conjunction with a
GROUP BY clause within
SELECT statements to limit your view to groups whose aggregate values meet specific criteria.
The expressions in a HAVING clause may contain constants, set functions or an exact replica of one of the expressions in the
GROUP BY expression list.
The use of aliases is allowed within the HAVING clause. The alias must differ from any column names within the table.