Which of the following queries will correctly return the manager information sorted by the
manager’s last name, department and project name?
A.
SELECTlastname, dept, projname, manager, startdate
FROM (SELECT name, dept, proj AS projname, manager, startdate
FROM employee, project
WHERE empno = empno) AS empproj
ORDER BY name, dept, projname
B.
SELECTlastname, dept, projname, manager, startdate
FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate
FROM employee, project
WHERE empno = mgrno) AS empproj
SORT BY lastname, firstname, dept, projname
C.
SELECTlastname, dept, projname, manager, startdate
FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate
FROM employee, project
WHERE empno = mgrno) AS empproj
ORDER BY lastname ASC
SORT BY dept, projname DESC
D.
SELECTlastname, dept, projname, manager, startdate
FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate
FROM employee, project
WHERE empno = mgrno) AS empproj
ORDER BY lastname, dept, projname