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
ORDER BY workdept
GROUP BY 2
B. SELECT workdept, AVG(salary)
FROM employee
ORDER BY workdept
ARRANGE BY 2
C. SELECT workdept, AVERAGE(salary)
FROM employee
GROUP BY workdept
ORDER BY 2
D. SELECT workdept, AVG(salary)
FROM employee
GROUP BY workdept
ORDER BY 2
|
Download Printable PDF. VALID exam to help you PASS. |
 |