☑Kizspy.me
Question 2:
Picture 1.1
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: 5
RecordDate
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:
Patient diagnosed with Migraine. Treatment: Surg.
Patient diagnosed with Diabetes. Treatment: Surg...
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
2020-05-10 00:00:00.000
2020-05-11 00:00:00.000
2020-07-23 00:00:00.000
RecordID PatientID DoctorID AppointmentID Diagnosis
Treatment Notes
1
7
25
7
2
43
74
15
43
3
56
29
22
56
Migraine
4
62
18
22
62
Asthma
5
72
66
4
72
Migraine
6
80
4
6
80
7
88
65
13
88
8
135
24
135
138
63
138
10 152
152
Hypertension Surgery
Asthma Surgery
Surgery
Surgery
Surgery
Migraine Surgery
Infection Surgery
Hypertension Surgery
Migraine Surgery
Diabetes Surgery
Picture 2.1
Question 3:
Write a query to select RecordID, Diagnosis, Treatment, DoctorID, DoctorFullName,
PatientID, PatientFullName for all medical records having the diagnosis as 'Hypertension',
where PatientFullName is the concatenation of the patient's first name, a white space and
the patient's last name, as follows:
RecordID Diagnosis Treatment
PatientID PatientFullName
DoctorID DoctorFullName
1
6
Hypertension Surgery
18
Dr. John Smith
2
7
Hypertension Surgery
25
Dr. James Brown
39
4
David Jones
James Johnson
3
8
Hypertension Regular monitoring 9
Dr. James Johnson 4
James Johnson
4
18
Hypertension Medication
13
Dr. Emma Jules
60
Michael Wilson
Zoom
- FUO
+ 100%
Close
