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 3;
B.
ORDER BY DEPT NAME;
C.
ORDER BY’b’;
D.
ORDER BY DEPT_ID;