The HAVING Clause

This works in the same manner as the WHERE clause, and is used in conjunction with the GROUP BY clause. The difference is that the HAVING conditions are applied to records after they have been grouped, while the WHERE conditions are applied before the records are grouped. This allows you to restrict records according to the aggregated values.

The syntax is:

HAVING condition-list

where "condition-list" is a comma-separated list of conditions for fields.