If you have more than one column specified in the GROUP BY clause, the ROLLUP clause...
a) Automatically sorts the results in ascending order based on the grouped columns.
b) Allows you to create subtotals and grand totals for the grouped columns.
c) Groups the rows according to a hierarchy of columns specified in the GROUP BY clause.
d) Is not supported in SQL.
