☑Kizspy.me
Zoom
3 of 3
Paper No: 12
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
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. 2020-01-24 00:00:00.000
Patient diagnosed with Infection. Treatment: Surg... 2020-05-08 00:00:00.000
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 Appointment D Diagnosis
7
4
25
7
2
43
74
15
43
3
56
29
22
56
4
62
18
22
62
Asthma
S
72
66
4
72
Migraine
6
80
4
6
80
Migraine
88
65
13
88
8
135
24
25
135
138
63
24
138
10 152
50
152
Treatment
Hypertension Surgery
Asthma
Surgery
Migraine Surgery
Surgery
Surgery
Surgery
Infection Surgery
Hypertension Surgery
Migraine Surgery
Diabetes Surgery
Notes
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
DoctorID DoctorFullName
PatientID
1
6
Hypertension Surgery
18
Dr. John Smith
39
2
7
Hypertension Surgery
25
Dr. James Brown
4
PatientFullName
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
+ 100%
Close
