Question

Consider EMPLOYEE database. Create the database and run the following queries and write the result you get.

What would be the result of the following query (please create the resulting table will all the columns and rows)?

SELECT                      D.Dname, E.Lname, P.Pname FROM                         DEPARTMENT D, EMPLOYEE E, WORKS_ON W, PROJECT P WHERE                      D.Dnumber=E.Dno AND E.Ssn=W.Essn AND W.Pno=P.Pnumber ORDER BY                 D.Dname DESC, E.Lname DESC;