A.HAVINGB.ORDER BYC.WHERED.GROUP BY
A.DISTINCTB.ORDER BYC.GROUP BYD.HAVING
A.MAX()B.MIN()C.SUM()D.COUNT()