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

Which one Plz help me!
-0.43 >, <, or = {Negative} -2.3
Fill in the table with relationship’s intercepts y=-300+15x
how do i solve thisx/12= 0​
Malik spent 1/4 of his money shopping. The next day he spent 1/3 of the money he had left. Now he has $42. How many money did Malik have before he did any shopp
"Every year the king of the country of Ta-Shih (the Arabs of the Khalif empire) who is styled Su-tan (Sultan) sends tribute-bearers, and if in the country some
Which food molecule would you eat if you needed a quick boost of energy
Debra walks3.5 km every day. How far does she walk in 7 days? Write answer in meters.
A net ionic equation is an equation showing only the species that actually change during the reaction. A spectator ion remains unchanged in the reaction and app
Evaluate the limit as x goes to infinity of the product of x cubed and e raised to the power of negative x over 5