Which SQL statement will retrieve the department number (WORKDEPT) and average
departmental salary (SALARY) for all departments in a table named EMPLOYEE and
arrange the result set in ascending order by average departmental salary?

A.
SELECT workdept, AVG(salary) FROM employee GROUP BY workdept ORDER BY 2

B.
SELECT workdept, AVERAGE(salary) FROM employee GROUP BY workdept ORDER
BY 2

C.
SELECT workdept, AVG(salary) FROM employee ORDER BY workdept ARRANGE BY
2

D.
SELECT workdept, AVG(salary) FROM employee ORDER BY workdept GROUP BY 2