-- create
CREATE TABLE EMPLOYEE (
  empId int,
  name varchar(15),
  dept varchar(10)
);

-- insert
-- INSERT INTO EMPLOYEE(empId,name,dept) VALUES (0, 'Clark', 'Sales');
-- INSERT INTO EMPLOYEE(empId,name,dept) VALUES (0, 'Dave', 'Accounting');
-- INSERT INTO EMPLOYEE(empId,name,dept) VALUES (0, 'Ava', 'Sales');

-- fetch 
SELECT SUM(empID) FROM EMPLOYEE GROUP BY GROUPING SETS (());