having with where

SQL HAVING clause  specifies that a SQL select  statement should only return rows where aggregate values meet the specified conditions.