Kizspy.me
CustID: int
FullName
FirstName
nvarchar(30)
nvarchar(60)
phone:
nvarchar(100)
LastName
nvarchar(30)
Picture 1.1
cardTypes
varchar(30)
money
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
RecordID PatientID DoctorID AppointmentiD Diagnosis
Treatment Notes
7
2
43
56
62
5
72
6
80
7
88
8
135
9
138
10 152
**********
4
25
7
74
15
43
29
22
56
Migraine
18
22
62
Asthma
66
72
Migraine
4
6
80
Migraine
65
13
88
Infection
24
25
135
50
138
152
Diabetes
Hypertension Surgery
Asthma
Surgery
Surgery
Surgery
Surgery
Surgery
Surgery
Hypertension Surgery
Migraine Surgery
Surgery
2
3
4
5
6
7
8
9
10
43
62
80
88
ឌ ខ ខ ន ឧ ឧ ឩ ខ្ច ខ្ច
15
43
56
56
18
62
66
4
72
6
80
65
13
88
135
24
25
138
63
24
ឌ ឌ ខ ន ឧ ឧ ≥ គឺ ៖
Asthma
Asthma
Migraine
Migraine
135
138
152
Diabetes
Surgery
Migraine Surgery
Surgery
Surgery
Surgery
Infection
Surgery
Hypertension Surgery
Migraine Surgery
Surgery
Zoom
- FUO
+ 100%
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
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
Patient diagnosed with Asthma. Treatment: Surgery. 2020-01-25 00:00:00.000
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-07-23 00:00:00.000
2020-05-11 00:00:00.000
Close
