Question

Who is currently using which computer at WP? Create an appropriate SQL query to answer this question. Show SerialNumber, Make, and Model. Show EmployeeID, LastName, FirstName, Department, and OfficePhone. Sort first by Department and then by employee LastName. Save this query using the query naming rules in exercise AW.3.1.

Answer 1

A,C,E

Step-by-step explanation:

On Edge 2020!

Answer 2

Check the explanation

Step-by-step explanation:

For SQL server and mySQL:

SELECT C.SerialNumber, Make, Model, E.EmployeeNumber,

LastName, Firstname, Department, OfficePhone

FROM COMPUTER AS C JOIN COMPUTER ASSIGNMENT AS CA

ON C.SerialNumber=CA.SerialNumber

JOIN EMPLOYEE AS E ON

CA.EmployeeNumber=E.EmployeeNumber

WHERE DateReassigned IS NULL

ORDER BYDepartment, LastName;