OCP CBT Question 527

Please solve the following question.

You want to retrieve `department_id`, `job_id`, and `salary` for all employees, sorted primarily by `department_id` in ascending order, and then by `salary` in descending order. Which SQL statement achieves this requirement?

EMPLOYEES Table Structure (relevant columns)
Name                           Null?    Type
------------------------------ -------- -------------
SALARY                                  NUMBER(8,2)
JOB_ID                         NOT NULL VARCHAR2(10)
DEPARTMENT_ID                           NUMBER(4)

SELECT department_id, job_id, salary FROM employees ORDER BY department_id ASC, salary DESC;

SELECT department_id, job_id, salary FROM employees ORDER BY department_id, salary;

SELECT department_id, job_id, salary FROM employees ORDER BY salary DESC, department_id ASC;

SELECT department_id, job_id, salary FROM employees SORT BY department_id ASC, salary DESC;