View the exhibit and examine the description of the EMPLOYEES table. (Choose two.) 

You executed this SQL statement: SELECT first_name, department_id, salary FROM employees - ORDER BY department_id, first_name, salary desc; Which two statements are true regarding the result? (Choose two.) 

Answer options:

A. The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.
B. The values in the FIRST_NAME column would be returned in ascending order for all employees having the same value in the DEPARTMENT_ID column.
C. The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.
D. The values in all columns would be returned in descending order.
E. The values in the FIRST_NAME column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.

AB