One or more conditional expressions that must be satisfied by the result rows. You can specify aggregate operators, scalar subqueries, and DEFAULT functions as conditional expressions with HAVING.
HAVING search_condition selects rows from a single group defined in the SELECT expression list that has only aggregate results, or it selects rows from the group or groups defined in a GROUP BY clause.
The HAVING search condition cannot reference BLOB, CLOB, ARRAY, or VARRAY columns.
If you specify the value for a row-level security constraint in a search condition, that value must be expressed in its encoded form.