Expressions coded in the HAVING clause

a$.$ can use aggregate search conditions but can$$t use non$-$aggregate search conditions

b$.$ can refer to any column in the base tables

c$.$ can use non$-$aggregate search conditions but can$$t use aggregate search conditions

d$.$ can use either aggregate search conditions or non$-$aggregate search conditions