Please answer 5.5 and 5.6 and show chart screenshot.
5. Assume that based on your suggestions and their additional requirements, Garden Glory designs a trail database saved as Garden_Glory.accdb in MS Access. Query the trail database using SQL statements and answer the following questions. For each SQL statement you write, show the results based on your data (you could press the "PrtSc - Print Screen" key to capture the results image).
5.5) Write an SQL statement to list the names of employees who have worked on a property owned by a Corporation.
5.6) Write an SQL statement to show the name and sum of HoursWorked for each employee.
PropertyName Eastlake Building Elm St Apts Jefferson Hill Eastlake Building Eastlake Building Elm St Apts Eastlake Building
Type Office Apartment Office Office Office Apartment Office
Street 123 Eastlake 4 East Elm 42 West 7th St 123 Eastlake 123 Eastlake 4 East Elm 123 Eastlake
City Seattle Lynnwood Bellevue Seattle Seattle Lynnwood Seattle
ZIP ServiceDate 98119 5/5/2008 98223 5/8/2008 98040 5/8/2008 98119 5/10/2008 98119 5/12/2008 98223 5/15/2008 98119 5/19/2008
Description Lawn Mow Lawn Mow Garden Service Lawn Mow Lawn Mow Lawn Mow Lawn Mow
Amount S 42.50 S 123.50 S 53.00 S 42.50 S 42.50 S 123.50 S 42.50