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 employeeORDER BY workdeptGROUP BY 2
B. SELECT workdept, AVG(salary)FROM employeeORDER BY workdeptARRANGE BY 2
C. SELECT workdept, AVERAGE(salary)FROM employeeGROUP BY workdeptORDER BY 2
D. SELECT workdept, AVG(salary)FROM employeeGROUP BY workdeptORDER BY 2
|
Download Printable PDF. VALID exam to help you PASS. |
 |