Question $25$

$3$ Points

Retrieve a list of employees and the projects each works in$,$ ordered by the employee's department, and within each department ordered alphabetically by employee last name.

Given:

EMPLOYEE $($NAME$,$ SSN$,$ BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNo$)$ DEPARTMENT $($NAME$,$ DNUMBER, MGRSSN$,$ MGRSTARTDATE$)$

PROJECT $($PNO$,$ PNAME, LOCATION$)$

WORKS$\_$ON $($ESSN$,$ PNo, Hours$)$