Kizspy.me 6
18
22
62
Asthma
5
72
66
4
72
Migraine
80
4
6
80
Migraine
88
65
13
88
Infection
8
135
24
25
135
9
138
63
24
10 152
50
4
138
152
Surgery
Surgery
Surgery
Surgery
Hypertension Surgery
Migraine Surgery
Diabetes Surgery
Patent 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...
Picture 2.1
Question 3:
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
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:
AppointmentID AppointmentDate
DoctorID DoctorFullName
1
2
2
3
3
4
26
5
42
2022-03-01 00:00:00.000 1
2021-06-02 00:00:00.000 11
2021-05-06 00:00:00.000 1
2019-12-21 00:00:00.000 6
2024-03-29 00:00:00.000 6
Dr. David Davis
Dr. Emma Johnson
Dr. David Davis
Dr. John Taylor
Dr. John Taylor
6
49
7
51
8
61
9
66
10 70
11
78
12
80
13
83
14
87
15
89
16
91
17 93
18
97
19
102
20
105
21
124
126
23
139
24
140
25
144
26
153
27
160
2021-09-24 00:00:00.000 6
2020-03-01 00:00:00.000 1
2022-12-01 00:00:00.000 11
2021-01-17 00:00:00.000 6
2021-01-12 00:00:00.000 1
2024-06-21 00:00:00.000 1
2020-01-24 00:00:00.000 6
2019-08-29 00:00:00.000 11
2022-01-12 00:00:00.000 11
2021-08-22 00:00:00.000 1
2019-05-17 00:00:00.000 1
2020-01-30 00:00:00.000 7
2020-04-28 00:00:00.000 11
2021-12-26 00:00:00.000 1
2023-03-26 00:00:00.000 7
2022-01-07 00:00:00.000 7
2019-04-01 00:00:00.000 7
2024-04-04 00:00:00.000 7
2022-07-25 00:00:00.000 6
2024-06-20 00:00:00,000 6
2021-07-06 00:00:00.000 11
2019-08-06 00:00:00.000 6
Dr. John Taylor
Dr. David Davis
Dr. Emma Johnson
Dr. John Taylor
Dr. David Davis
Dr. David Davis
Dr. John Taylor
Dr. Emma Johnson
Dr. Emma Johnson
Dr. David Davis
Dr. David Davis
Dr. James Miller
Dr. Emma Johnson
Dr. David Davis
Dr. James Miller
Dr. James Miller
Dr. James Miller
Dr. James Miller
Dr. John Taylor
Dr. John Taylor
Picture 3.1
2222222222222
Specialty PatientID PatientFullName
Orthopedics 49
Orthopedics 54
Orthopedics 53
Orthopedics 18
Orthopedics 78
Orthopedics 12
Orthopedics 41
Orthopedics 57
Orthopedics 13
Orthopedics 57
Orthopedics 67
Orthopedics 4
Orthopedics 26
Orthopedics 49
Orthopedics 33
Orthopedics 4
Orthopedics 12
Orthopedics 33
Orthopedics 50
Orthopedics 35
Orthopedics 13
Orthopedics 44
Orthopedics 38
Orthopedics 54
Orthopedics 57
Dr. Emma Johnson Orthopedics 72
Dr. John Taylor Orthopedics 49
David Wilson
Sarah Wilson
Chris Davis
Chris Moore
David Williams
Emma Johnson
John Davis
James Davis
James Wilson
James Davis
Emma Taylor
James Johnson
David Jones
David Wilson
John Taylor
James Johnson
Emma Johnson
John Taylor
Laura Moore
Jane Moore
James Wilson
Emma Smith
Jane Williams
Sarah Wilson
James Davis
Michael Moore
David Wilson
Question 4:
+ 100%
Zoom
- FUO
Close
