Complete the queries below in SQL Server using the Sports Database.

1. For every patient, list the patient number, therapist ID, and the therapy description.

2. List the patient name for each patient assigned to therapist, Anthony Shields.

3. List the first and last name of all therapists that have seen patients that live in zip codes 72381, 74093 and 76658. Use the IN operator in your query.

4. List the Therapy description(s) that therapist Bridgett McClain conducted.

5. Repeat exercise 3 and use the EXISTS operator.

6. Use a subquery to find the first and last name of each therapist who had a session with at least one patient with a balance greater than 1,000.00.

7. Find the first and last name of each therapist who had a session with patients that live in Waterville.

8. List the average length of session from the Session table.

9. List the patient first name(s) and last name(s) where the length of the session was greater than the average length of all sessions.