2. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master.

3. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master and FirstName that begins with the letter J.

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.