Kizspy.me
Zoom
CustID: Int
FulName
nvarchar(60)
Customers
phone
varchar(100)
FirstName
nvarchar(30)
LastName
nvarchar(30)
Picture 1.1
Cards
салатуре:
varchar(30)
creditimit
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: 2
RecordID Patient DoctoriD AppointmentD Diagnosis
Treatment Notes
1
7
25
7
2
43
74
15
43
3
56
29
22
56
4
62
18
22
62
5
72
66
4
72
6 80
4
6
7
88
65
13
135
24
25
9138
63
24
10 152
50
4
ཐཛཿམཟཕསམམ་
Asthma
Migraine
Hypertension Surgery
Asthma Surgery
Migraine Surgery
Surgery
Surgery
Migraine
Infection
135
138
152
Surgery
Surgery
Hypertension Surgery
Migraine Surgery
Diabetes Surgery
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
Picture 2.1
Question 3:
Write a query to select AppointmentID, AppointmentDate, DoctorID, DoctorFullName,
Specialty, PatientID, PatientFullName for all appointments of all doctors having the specialty
'Orthopedics'; where PatientFullName is the concatenation of the patient's first name, a
white space and the patient's last name, as follows:
+ 95%
Close
