Which two ORDER BY clauses can be used to sort the output of the above statement?

View the Exhibit and examine the data in the DEPARTMENTS tables.

Evaluate the following SQL statement:

Which two ORDER BY clauses can be used to sort the output of the above statement? (Choose two.)

A.
ORDER BY 3;

B.
ORDER BY ‘b’;

C.
ORDER BY DEPT_ID;

D.
ORDER BY DEPT_NAME;