☑Kizspy.me
emplo: int
FirstName:
nvarchar(30)
FullName
nvarchar(60)
LastName:
nvarchar(30)
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: 5
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.
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
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
4
25
7
2
43
74
15
43
3
56
29
22
56
62
18
22
62
Asthma
5
72
66
4
72
Migraine
6
80
4
6
80
7
88
65
13
88
8
135
24
25
135
138
138
10
152
50
152
Diabetes
Hypertension Surgery
Asthma Surgery
Migraine Surgery
Surgery
Surgery
Migraine Surgery
Infection Surgery
Hypertension Surgery
Migraine
Surgery
Surgery
Picture 2.1
Zoom
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
+ 100%
Close
