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 $($FName$,$ Minit, LName, Ssn$,$ Bdate, Address, Sex, Salary, SuperSsn, Dno$)$

PROJECT $($PName$,$ Pnumber, Plocation, Dnum$)$

DEPARTMENT $($Dname$,$ Dnumber, MgrSSN$,$ MgrStartDate$)$

WORKS$\_$ON $($ESsn$,$ Pno, Hours$)$