Question

Write an SQL statement to list the Name of employees who have worked on a property in New York .

Answer 1

Querying a SQL database.

Step-by-step explanation:

SELECT Last Name, First Name

FROM EMPLOYEE

WHERE Employee ID IN

(SELECT EmployeeID

FROM PROPERTY_SERVICE

WHERE PropertyID IN

(SELECT PropertyID

FROM OWNED_PROPERTY

WHERE City = 'Newyork'));