Request for SQL Equivalent of HAVING for Result Filtering

It would be good to be able to do the equivalent of "HAVING" in SQL for filtering out results. e.g., you do an insight of # of sessions, broken down by location, but you only want the report (table) and percent to total calcs to include those locations that had >10 session. SELECT from {xyz} WHERE {abc} GROUP BY {def} HAVING {123}.