Consider the relations shown in the exhibit. Due to restructuring, the sales department has been
eliminated and the employees working in that department have been dismissed. All ID information
is stored as integers. Which SQL statement would be used to return a relation with all information
for the employees who have been dismissed?
A.
SELECT *
FROM Employee;
B.
SELECT ID,Last_Name
FROM Employee;
WHERE ID = 0004;
C.
SELECT *
FROM Employee
WHERE Dept_ID = 022;
D.
SELECT *
FROM Employee
WHERE Dept_ID = 022;