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

Two glasses together contain 280 mLof water. The first glass contains 80 ml more than the second glass. How much water does the first glass contain?
Two end uses of wool
the ill effects of building a dam on a major river.
How do you write this in a algebraic equation: 6 more than 7 times a number is 41
Need the values IN FRACTIONS (no mixed numbers or decimals)1. -1/2^12. -1/2^23. -1/2^34. -1/2^45. -1/2^5
Need the values IN FRACTIONS (no mixed numbers or decimals)1. -1/2^12. -1/2^23. -1/2^34. -1/2^45. -1/2^5
if a+b+c=0 for a,b,c then prove a²/bc+b²/ca+c²/ab=3.
the sum of Marys age and her moms age is 67.  Three times Marys age increased by 7 is her moms age.  How old is Mary and her mother
Newspaper headlines don’t follow the rules of grammar. Do you agree? Substantiate your arguments with proper evidences.
What is the answer to 5x-7y=14