Write an sql statement to list the name of employees who have worked on a property in new york .

Querying a SQL database.

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'));

answerapplication;

the answer is e ; )(: