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