Given the following table definition:
EMPLOYESS
————————–
EMP ID INTEGER
NAME CHAR(20)
DEPT CHAR(10)
SALARY DECIMAL (10, 2)
COMMISSION DECIMAL (8, 2)
Assuming the DEPT column contains the values ‘ADMIN’, ‘PRODUCTION’, and ‘SALES’, which of
the following statements will produce a result data set in which all ADMIN department employees
are grouped together, all PRODUCTION department employees are grouped together, and all
SALES department employees are grouped together?

A.
SELECT name, dept FROM employees ORDER BY dept

B.
SELECT name, dept FROM employees GROUP BY dept

C.
SELECT name, dept FROM employees GROUP BY ROLLUP (dept)

D.
SELECT name, dept FROM employees GROUP BY CUBE (dept)