Complete the queries below in SQL Server using the Sports Database. Save the file as Assignment5.sql 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, PatientNum 1010 1011 1012 LastName FirstName Koehler Robbie King Joseph Houghland Susan Zipcode 72510 74081 72380 Balance 1535.15 212.8 1955.4 1000.35 1013 Falls 72511 Tierra 74093 1014 525 Odepaul TX Ben Address City State 119 West Bay Dr. San Vista TX 941 Treemont Oak Hills TX 7841 Lake Side Dr. Munster TX 44 Applewood Ave. Palm Rivers TX 546 WCR 150 South Munster 37 High School Road Waterville TX 2691 Westgrove St. Delbert TX 1928 10th Ave. Munster TX 300 Erin Dr. waterville TX 4238 East 71st St. San Vista TX 919 Horton Ave. Georgetown TX 424 October Blvd Waterville TX 74183 432.3 1015 Isaiah Venable 1016 1017 1018 1019 1020 1021 Waggoner Brianna Short Tobey Baptist Joseph Culling Latisha Marino Andre Wilson Tammy 72381 72512 76658 74071 72379 76658 714.25 967.6 1846.75 1988.5 688.95 2015.3 SessionNum 27 28 29 30 31 32 33 34 35 36 37 38 SessionDate 2018-10-10 2018-10-11 2018-10-11 2018-10-12 2018-10-15 2018-10-16 2018-10-17 2018-10-17 2018-10-18 2018-10-18 2015-10-19 2018-10-19 Patient Num 1011 1016 1014 1013 1016 1018 1017 1015 1010 1019 1020 1021 Lengthofsession Therapistin TherapyCode 45 JRO85 92507 30 AS648 97010 60 SW124 97014 30 BM273 97033 90 AS648 98960 15 JR085 97035 60 SN852 97039 45 BM273 97112 30 5W124 97113 75 SN852 97116 30 BM273 97124 60 AS648 97535 UnitofTime 15 TherapyCode Description 90901 Biofeedback training by any modality 92240 Shoulder strapping 92507 Treatment of speech 92530 Knee strapping 92540 Ankle and/or foot strapping 95831 Extremity or trunk muscle testing 97010 Hot or cold pack application 97012 Mechanical traction 97014 Electrical stimulation 97016 Vasopneumatic devices 97015 Paraffin bath 97022 Whirlpool 97026 Infrared 97032 Electrical stimulation 97033 iontophoresis 97035 Ultrasound 97039 Unlisted modality 97110 Therapeutic exercises to develop strength and endurance, range of motion, and flexibility 97112 Neuromuscular re-education of movement, balance, coordination, etc. 97113 Aquatic therapy with therapeutic exercises 97116 Gait training 97124 Massage 97139 Unlisted therapeutic procedure 97140 Manual therapy techniques 97150 Group therapeutic procedure Dynamic activities to improve functional performance, direct (one-on-one) with the 97530 patient 97535 self-care/home management training 97750 Physical performance test or measurement 97799 Unlisted physical medicine/rehabilitation service or procedure 95941 CMT of the spine 98960 Education and training for patient self-management 15 15 15 15 15 15 15 15 15 15 15 15 15 13 BO Therapistid LastName FirstName Street AS648 BM273 Shields Mcclain Anthony Bridgette 5222 Eagle Court 385 West Mill St. City State ZipCode Palm Rivers TX 72511 Waterville TX 76658 Palm Rivers TX 72511 Livewood TX 72512 JROBS SN852 Risk Nair Jonathan Saritha 1010 650 North 25 North Elm St. 7354 Rockville Road SW124 Wilder Steven TX 72510 San Vista
