Kizspy.me
Picture 1.1
Question 2:
Display all medical records in which the treatment is 'Surgery' and the record date is in the
year 2020 as follows:
3 of 3
Paper No: 4
RecordDate
2020-09-28 00:00:00.000
2020-01-25 00:00:00.000
2020-06-24 00:00:00.000
2020-02-15 00:00:00.000
2020-02-04 00:00:00.000
2020-01-24 00:00:00.000
2020-05-08 00:00:00.000
Patient diagnosed with Hypertension. Treatment
Patient diagnosed with Asthma. Treatment: Surgery.
Patient diagnosed with Migraine. Treatment: Surg..
Patient diagnosed with Asthma. Treatment: Surgery.
Patient diagnosed with Migraine. Treatment: Surg...
Patient diagnosed with Migraine. Treatment: Surg...
Patient diagnosed with Infection. Treatment: Surg...
Patient diagnosed with Hypertension. Treatment:... 2020-05-10 00:00:00.000
Patient diagnosed with Migraine. Treatment: Surg 2020-05-11 00:00:00.000
Patient diagnosed with Diabetes. Treatment: Surg. 2020-07-23 00:00:00.000
RecordID PatientiD DoctorID AppointmentID Diagnosis
Treatment Notes
1
7
4
25
7
2
43
74
15
43
56
29
22
56
Asthma
Migraine
4
62
18
22
62
Asthma
5
72
66
4
72
6
80
4
6
80
7
88
65
13
88
8
135
24
25
135
9
138
138
10 152
50
152
Diabetes
Hypertension Surgery
Surgery
Surgery
Surgery
Migraine Surgery
Migraine
Surgery
Infection Surgery
Hypertension Surgery
Migraine Surgery
Surgery
Picture 2.1
Question 3:
Write a query to select AppointmentID, AppointmentDate, DoctorID, DoctorFullName,
Specialty, PatientID, PatientFullName for all appointments of all doctors having the specialty
'Orthopedics'; where PatientFullName is the concatenation of the patient's first name, a
white space and the patient's last name, as follows:
AppointmentID AppointmentDate
1
1
2
2
3
3
4
26
5
42
6
49
DoctorID DoctorFullName
2022-03-01 00:00:00.000 1
2021-06-02 00:00:00.000 11
2021-05-06 00:00:00.000 1
2019-12-21 00:00:00.000 6
2024-03-29 00:00:00.000 6
2021-09-24 00:00:00.000 6
Dr. David Davis
Dr. Emma Johnson
Dr. David Davis
Dr. John Taylor
Dr. John Taylor
Dr. John Taylor
Specialty
Orthopedics 49
Orthopedics 54
Orthopedics 53
Orthopedics 18
Orthopedics 78
Orthopedics 12
PatientID PatientFullName
David Wilson
Sarah Wilson
Chris Davis
Chris Moore
David Williams
Emma Johnson
Zoom
- FUO
+ 100%
Close
