HAVING clause is identifical to the WHERE clause, and is applied after the
GROUP BY clause.
Boolean predicates follow SQL’s 3-valued logic.
PartiQL has two kinds of absent values:
MISSING— as far as
IS NULLis concerned, a
NULLinput and a
MISSINGinput behave identically.
Alike SQL, when the expression of the
HAVINGclause predicate evaluates to an absent value or a value that is not a Boolean, PartiQL eliminates the corresponding binding.