tytianas168 tytianas168
  • 17-01-2020
  • Computers and Technology
contestada

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

Respuesta :

IfeanyiEze8899 IfeanyiEze8899
  • 18-01-2020

Answer:

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

Answer Link

Otras preguntas

A(n) is a comparison over the course of a poem
Harold bought 5 apples for $ 1.30. What is the unit price?
How has the day to day workings of government affected how we interpret the constitution?
What is the drawing technique of using dots to create degrees of shading or solidity instead of using lines? cross-hatching dotting stippling NextReset
To address problems caused by the dissolution of the Soviet Union some Eastern European nations _____. privatized industry increased foreign investment increase
What is the mass of 5.33×1021 platinum atoms
An adult sleeps about 480 per day. In infant sleeps about 820 minutes per day. About how many more minutes does an infant sleep than an adult in one week?
What is .466666 as a fraction?
a car slows down from 23 m/s to rest in a distance of 85m. what was its acceleration, assumed constant?
A technician who specializes in repairing only one type of automotive system is a/an