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

Geometry Help? Plz I Beg Of You!! *pic inside*
Help with this for science homeworK!!!
Which type of energy increases when you compress a spring? A. Elastic Potential Energy B. Kinetic Energy C. Radiant Energy D. Sound Energy
what are characteristics of a tragic drama
What is the answer? Please Help!
A football field is about 100m long. If it takes a person 20s to run its length, how fast were they running?
Can someone help me? (Click picture below for question)
The main purpose of the Albany Congress of 1754 was to (A) draw up a treaty with the Native Americans (B) protest restrictions on western settlements put in p
do laws change and even disappear as ethical beliefs change?
Write the product as the product of a whole number and a unit fraction 2x4\5=