Construction should include the following:
A WHERE clause may still be used to limit the results used to calculate the group function.
The HAVING clause restricts the groups included in the GROUP BY.