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

Frances is sewing a border around 2 rectangular tablecloths that each measure 9 feet long by 6 feet wide.  If it takes her 3 minutes to sew on 1 inch of border,
what is the square root of 600?
Please help the question is in the picture x
What is the distance in space between the points with coordinates (-3,6,7) and (2,-1,4) ?
the rule for this number sequence is (n+3) x 2 where n is the previous number in the sequence.6   18  42 ? type the missing numberplease
Jerry built a chest shaped like a rectangular solid. The base was 14 inches long and 10 inches wide. It had a height of 4 inches. What is the area of the base
Please help the question is in the picture x
what is the period of the graph of the equation y=3cos2x
When 16x cubed - 12x squared + 4x is divided by 4x , the quotient is
What is the distance in space between the points with coordinates (-3,6,7) and (2,-1,4) ?