View the Exhibit and examine the data in the DEPARTMENTS tables.Evaluate the following SQL statement:SELECT department_i
Posted: Wed Jun 07, 2023 6:11 am
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;
A. ORDER BY 3;
B. ORDER BY 'b';
C. ORDER BY DEPT_ID;
D. ORDER BY DEPT NAME;