DROP TABLE table_stats

CREATE TABLE tab_ent_stats(ent_name VARCHAR2(100), ent_type VARCHAR2(100), rec_count NUMBER, occupied_storage NUMBER)

INSERT INTO tab_ent_stats VALUES('Mgmt1','State1',18900,1786)

INSERT INTO tab_ent_stats VALUES('Mgmt1','State2',28900,2786)

INSERT INTO tab_ent_stats VALUES('Mgmt2','State1',38900,3786)

INSERT INTO tab_ent_stats VALUES('Mgmt2','State2',48900,4786)

INSERT INTO tab_ent_stats VALUES('Mgmt3','State1',58900,5786)

COMMIT

SELECT ent_name, ent_type, SUM(rec_count) AS rec_count, SUM(occupied_storage) AS "OCCUPIED_STORAGE(MB)"
FROM tab_ent_stats
GROUP BY ROLLUP (ent_name,ent_type)
ORDER BY ent_name,ent_type