When HAVING appears in a SQL statement, this implies that there is a GROUP BY clause in the statement. If WHERE is also in the statement, the WHERE clause creates the first subset. The HAVING clause makes a "second pass" after the GROUP BY clause and makes a sub-sub-set.