Rollup and Cube for Aggregated Summaries

ROLLUP and CUBE generate hierarchical or multidimensional aggregated summaries.

SELECT product_id, region, SUM(sales)
FROM sales_data
GROUP BY ROLLUP (product_id, region);