Please write in MySQL OWNER ( OwnerID, OwnerName, OwnerEmail, OwnerType ) PROPER
ID: 3678574 • Letter: P
Question
Please write in MySQL
OWNER ( OwnerID, OwnerName, OwnerEmail, OwnerType )
PROPERTY ( PropertyID, PropertyName, Street, City, State, Zip, OwnerID )
EMPLOYEE ( EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel )
SERVICE ( PropertyID, EmployeeID, ServiceDate, HoursWorked )
Write an SQL statement to list LastName and FirstName of employees who have worked on a property in Bellevue. Use a subquery. The result should look like the following:
Enter your answer below
Explanation / Answer
Select LastName, FirstName FROM EMPLOYEE (SELECT City FROM PROPERTY WHERE City = 'Bellevue');