used to find the groups forming the subtotal in a row

used to identify the NULL value in the aggregate function.

use to form the group sets involved in generating the totals and subtotals

only be used with ROLLUP and CUBE operators specified in the GROUP BY clause