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: SELECT department_id “DEPT_ID”, department_name , ‘b’
FROM departments WHERE department_id=90 UNION SELECT department_id,
department_name DEPT_NAME, ‘a’ FROM departments WHERE department_id=10 Which
two ORDER BY clauses can be used to sort the output of the above statement? (Choose
two.)

A.
ORDER BY DEPT_ID;

B.
ORDER BY DEPT NAME;

C.
ORDER BY ‘b’;

D.
ORDER BY 3;