Question: Using SQL, can you please show me how to set up number 7 and 8? I am using microsoft access. 7. Write an SQL script
Using SQL, can you please show me how to set up number 7 and 8? I am using microsoft access.
7. Write an SQL script to provide all discharge information (e.g., MRN, Discharge Date, Admit Date, etc.) for ALL MD type physicians that have Aetna Insurance.
8. Write an SQL script to find average patient satisfaction scores for each physician. Also provide the number of patients seen per physician. Be sure and title the fields as Physican Name, Number of Patients, Average Patient Satisfaction Score. (Use Patient_Discharge_Information_Table AND Physician_Information Table).
Query5 X Query6 X Physician_ID 8 1 5 7 Patient_Discharge_Information X Query2 X Query3 x Query4 X ID Medical_Record_Number Admit_Date - Length_of_Stay 86 3022594 2/27/16 87 5001328 3/9/16 88 7687499 5/30/16 89 4303365 3/2/16 90 4499173 1/25/16 91 5546597 2/26/16 92 7687499 6/5/16 93 3648185 6/4/16 94 4499173 4/8/16 95 6483334 5/1/16 96 8407693 4/4/16 97 7761534 4/9/16 98 7687499 5/27/16 99 3683360 4/10/16 100 4855584 2/19/16 101 4499173 4/12/16 102 4864694 1/13/16 103 8407693 4/20/16 104 6375564 5/8/16 105 6483334 3/28/16 106 5167312 5/20/16 107 5546597 1/18/16 108 6943265 6/19/16 Physician_Information X Discharge_Date 114 3/12/16 3 3/12/16 7 6/6/16 11 3/12/16 10 2/4/16 13 3/10/16 3 6/8/16 4 6/8/16 12 4/20/16 6 5/7/16 1 4/5/16 11 4/20/16 2 5/29/16 7 4/17/16 3 2/22/16 14 4/26/16 13 1/26/16 5 4/25/16 4 5/12/16 6 4/3/16 1 5/21/16 6 1/24/16 1 6/20/16 OVVw U V NOW WV W NOU UP 4 Query5 X Query6 X Physician_ID 8 1 5 7 Patient_Discharge_Information X Query2 X Query3 x Query4 X ID Medical_Record_Number Admit_Date - Length_of_Stay 86 3022594 2/27/16 87 5001328 3/9/16 88 7687499 5/30/16 89 4303365 3/2/16 90 4499173 1/25/16 91 5546597 2/26/16 92 7687499 6/5/16 93 3648185 6/4/16 94 4499173 4/8/16 95 6483334 5/1/16 96 8407693 4/4/16 97 7761534 4/9/16 98 7687499 5/27/16 99 3683360 4/10/16 100 4855584 2/19/16 101 4499173 4/12/16 102 4864694 1/13/16 103 8407693 4/20/16 104 6375564 5/8/16 105 6483334 3/28/16 106 5167312 5/20/16 107 5546597 1/18/16 108 6943265 6/19/16 Physician_Information X Discharge_Date 114 3/12/16 3 3/12/16 7 6/6/16 11 3/12/16 10 2/4/16 13 3/10/16 3 6/8/16 4 6/8/16 12 4/20/16 6 5/7/16 1 4/5/16 11 4/20/16 2 5/29/16 7 4/17/16 3 2/22/16 14 4/26/16 13 1/26/16 5 4/25/16 4 5/12/16 6 4/3/16 1 5/21/16 6 1/24/16 1 6/20/16 OVVw U V NOW WV W NOU UP 4
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help