Which two statements are true regarding the output of the above query?

View the Exhibit and examine the description of the EMPLOYEES table.
You executed the following SQL statement:
SELECTfirst_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the output of the above query? (Choose two.)

A.
The values in all the columns would be sorted in the descending order.

B.
The values in the SALARY column would be sorted in descending order for all the
employees having the same value in the DEPARTMENT_ID column.

C.
The values in the FIRST_NAME column would be sorted in ascending order for all
the employees having the same value in the DEPARTMENT_ID column.

D.
The values in the FIRST_NAME column would be sorted in the descending order for
all the employees having the same value in the DEPARTMENT_ID column.

E.
The values in the SALARY column would be sorted in descending order for all the
employees having the same value in the DEPARTMENT_ID and FIRST_NAME
column.