4. Write an SQL statement to list the LastName and FirstName of employees who have worked on a property in Seattle. Use a subquery.

5. Answer question 4 but use a join using JOIN ON syntax.

6. Write an SQL statement to list the LastName and FirstName of employees who have worked on a property owned by a corporation. Use a subquery.

7. Answer question 6 but use a join using JOIN ON syntax.

8. Write an SQL statement to show the LastName and FirstName and sum of hours worked for each employee.

9. Write an SQL statement to show the sum of hours worked for each ExperienceLevel of EMPLOYEE. Sort the results by ExperienceLevel, in descending order.

10. Write an SQL statement to show the sum of HoursWorked for each type of OWNER but exclude services of employees who have ExperienceLevel of Junior.

EMPLOYEE Columns =5, Rows =7 \begin{tabular}{|l|l|l|c|l|} \hline EmployeelD & LastName & FirstName & CellPhone & ExperienceLevel \\ \hline 1 & Smith & Sam & 2062541234 & Senior \\ \hline 2 & Evanston & John & 2062542345 & Master \\ \hline 3 & Murray & Dale & 4255457654 & Junior \\ \hline 4 & Murphy & Gerry & 4255458765 & Senior \\ \hline 5 & Fontaine & Joan & 2062543456 & Master \\ \hline 6 & Mulburry & Davee & 4255467654 & Master \\ \hline 7 & Waters & Muddy & 4215457551 & Junior \\ \hline \end{tabular} GG_SERVICE Columns =3, Rows =7 \begin{tabular}{|l|l|l|} \hline ServicelD & ServiceDescription & CostPerHour \\ \hline 1 & Mow Lawn & 25.00 \\ \hline 2 & Plant Annuals & 25.00 \\ \hline 3 & Weed Garden & 30.00 \\ \hline 4 & Trim Hedge & 45.00 \\ \hline 5 & Prune Small Tree & 60.00 \\ \hline 6 & Trim Medium Tree & 100.00 \\ \hline 7 & Trim Large Tree & 125.00 \\ \hline \end{tabular} Rows =8 PROPERTY_SERVICE Columns =6, Rows =13 \begin{tabular}{|l|l|l|l|l|l|} \hline PropertyServicelD & PropertyID & ServicelD & ServiceDate & EmployeelD & HoursWorked \\ \hline 1 & 1 & 2 & 20140505 & 1 & 4.50 \\ \hline 2 & 3 & 2 & 20140508 & 3 & 4.50 \\ \hline 3 & 2 & 1 & 20140508 & 2 & 2.75 \\ \hline 4 & 6 & 1 & 20140510 & 5 & 2.50 \\ \hline 5 & 5 & 4 & 20140512 & 7 & 7.50 \\ \hline 6 & 8 & 1 & 20140515 & 4 & 2.75 \\ \hline 7 & 4 & 4 & 20140519 & 1 & 1.00 \\ \hline 8 & 7 & 1 & 20140521 & 2 & 2.50 \\ \hline 9 & 6 & 3 & 20140603 & 5 & 2.50 \\ \hline 10 & 5 & 7 & 20140608 & 6 & 10.50 \\ \hline 11 & 8 & 3 & 20140612 & 4 & 2.75 \\ \hline 12 & 4 & 5 & 20140615 & 1 & 5.00 \\ \hline 13 & 7 & 3 & 20140619 & 2 & 4.00 \\ \hline \end{tabular}