Restricting Groups
In the same way that you use the WHERE clause to restrict rows that are retrieved, you can use the HAVING clause to restrict groups that are retrieved.
Sheila researched the HAVING clause and found that it is placed immediately after the GROUP BY clause in the syntax. You specify the HAVING keyword followed by a condition that refers to a group of rows. You cannot use a HAVING clause in a statement without a GROUP BY clause.
