group by cube

CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY  clause.