显示员工的信息，按照department_id的降序排列，salary的升序排列

A、SELECT last_name, salary, department_id FROM employees ORDER BY department_id DESC, salary ASC
B、SELECT last_name, salary, department_id FROM employees ORDER BY department_id ASC, salary DESC
C、SELECT last_name, salary, department_id FROM employees ORDER BY salary ASC
D、SELECT last_name, salary, department_id FROM employees ORDER BY department_id DESC