IBM
C2090-610 · Question #117
C2090-610 Question #117: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-610 to reveal the answer and full explanation for question #117. The question stem and answer options stay visible for context.
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)
Unlock C2090-610 to see the answer
You've previewed enough free C2090-610 questions. Unlock C2090-610 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.