DF198: COMPUTE or COMPUTE BY clause is used.

CREATE TABLE population
(
country VARCHAR(100),
[state] VARCHAR(100),
city VARCHAR(100),
[population (in millions)] FLOAT
)
GO
 
INSERT INTO POPULATION VALUES('USA', 'Texas','San Antonio',1.5)
INSERT INTO POPULATION VALUES('USA', 'Texas','Huston',2.3)
INSERT INTO POPULATION VALUES('USA', 'California','Los Angeles',3.9)
INSERT INTO POPULATION VALUES('USA', 'California','San Diego',1.4)
 
INSERT INTO POPULATION VALUES('India', 'Karnataka','Bangalore',9.5)
INSERT INTO POPULATION VALUES('India', 'Karnataka','Manipal',1.5)
INSERT INTO POPULATION VALUES('India', 'Delhi','East Delhi',9 )
INSERT INTO POPULATION VALUES('India', 'Delhi','South Delhi',8 )
GO
 
 
SELECT country, [state], city, [population (in millions)]
FROM POPULATION
ORDER BY country, [state], city
COMPUTE SUM([population (in millions)]) BY country,[state]
GO

SELECT country,[state],city,
SUM ([population (in millions)]) AS [population (in millions)] FROM POPULATION
GROUP BY country,[state],city
WITH ROLLUP
GO