ROLLUP Aggregations | Dataford Interview Questions

Describe how you would use ROLLUP to produce multi-level aggregations in SQL.

Explain what rows appear at each aggregation level and how subtotal and grand total rows are identified. Keep the answer focused on the result shape and ordering expectations.

Schema

sales

Column	Type	Description
sale_idPK	INT	Unique sale identifier
region	VARCHAR(50)	Sales region
product_category	VARCHAR(50)	Product category
sales_amount	DECIMAL(12,2)	Sales amount for the transaction

Your question is ROLLUP Aggregations. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Describe how you would use ROLLUP to produce multi-level aggregations in SQL.

Explain what rows appear at each aggregation level and how subtotal and grand total rows are identified. Keep the answer focused on the result shape and ordering expectations.

Schema

sales

Column	Type	Description
sale_idPK	INT	Unique sale identifier
region	VARCHAR(50)	Sales region
product_category	VARCHAR(50)	Product category
sales_amount	DECIMAL(12,2)	Sales amount for the transaction

Your question is ROLLUP Aggregations. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.