IBM
C2090-610 · Question #117
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…
The correct answer is D. SELECT workdept, AVG(salary). See the full explanation below for the reasoning.
Question
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?
Options
- ASELECT workdept, AVG(salary)
- BSELECT workdept, AVG(salary)
- CSELECT workdept, AVERAGE(salary)
- DSELECT workdept, AVG(salary)
How the community answered
(40 responses)- A8% (3)
- B13% (5)
- C3% (1)
- D78% (31)
Community Discussion
No community discussion yet for this question.