2020-02-15 00:00:00.000
2020-02-04 00:00:00.000
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
☑ Kizspy.me
62
18
22
62
Asthma
5
72
66
4
72
Migraine
6
80
4
6
80
7
88
65
13
88
Migraine
Infection
8
135
24
25
135
9
138
63
24
138
10 152
50
4
152
Surgery
Surgery
Surgery
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
DoctorID DoctorFullName
1
6
Hypertension Surgery
18
Dr. John Smith
PatientID
39
2
7
Hypertension Surgery
25
Dr. James Brown
4
3
8
Hypertension Regular monitoring 9
Dr. James Johnson 4
PatientFullName
David Jones
James Johnson
James Johnson
4
18
5
22
6
29
7
8
9
31
34
46
10
58
11
CASETE222222
79
12 85
13 96
14
15
16
17
18
19
20
21
23
24
ខ ៩៩៩៩ ៩ ៩ ៩ ៩ ៩ ៖ ៖ ៖ & គ ន - ៩ ន គ
Hypertension Medication
13
Dr. Emma Jules
60
Michael Wilson
Hypertension Regular monitoring 22
Dr. Michael Brown 44
Emma Smith
Hypertension Dietary changes
Hypertension Medication
23
Dr. Laura Miller
32
Laura Davis
23
Dr. Laura Miller
7
Sarah Williams
Hypertension Regular monitoring 8
Hypertension Medication
Dr. Michael Moore
72
Michael Moore
25
Dr. James Brown
56
Chris Johnson
Hypertension Regular monitoring 2
Hypertension Physical therapy
Dr. David Taylor
37
Sarah Miller
15
Dr. Emily Williams
65
Jane Miller
Hypertension Physical therapy
2
Dr. David Taylor
13
James Wilson
Hypertension Dietary changes
3
Dr. Laura Moore
66
Emma Smith
119
Hypertension Medication
121
Hypertension Physical therapy
126
Hypertension Surgery
7
134
Hypertension Surgery
135
Hypertension Surgery
142
Hypertension Physical therapy
143
Hypertension Physical therapy 9
Hypertension Medication
146
156
160
Hypertension Physical therapy 25
Hypertension Regular monitoring 24
Hypertension Rest
2212201226
23
Dr. Laura Miller
18
Chris Moore
23
Dr. Laura Miller
1
James Smith
Dr. James Miller
44
Emma Smith
Dr. David Miller
51
Jane Brown
25
Dr. James Brown
24
Chris Wilson
Dr. Michael John... 40.
Emily Taylor
Dr. James Johnson 71
Sarah Miller
14
Dr. John Wilson
28
John Taylor
Dr. James Brown
21
Laura Smith
Dr. Emma Jones
46
Jane Wilson
Dr. John Taylor
49
David Wilson
Picture 3.1
Question 4.
Zoom
+ 100%
Close
