Write a query to display PatientID, FirstName, LastName, DateOfBirth, Email of all distinct patients who had appointments with doctors of the department 'Cardiology' from the year 2021 to the year 2024; display the result in ascending order of PatientID as in the following
figure:
Zoom
4 of 4
Paper No: 3
PatientID
FirstName
LastName
DateOfBirth
Email
1
4
Diana
Taylor
1992-12-05
[email protected]
2
12
Lily
Rodriguez 1989-03-30
[email protected]
3
17
Quincy
Allen
4
22
Vera
5
39
Mia
Kim
6
41
Owen
Reed
7
51
Yasmine
Long
1990-01-02
[email protected]
Baker
1990-03-22
[email protected]
1982-08-21
[email protected]
1985-01-15
[email protected]
1985-01-15
[email protected]
8
53
Anna
Chapman
1988-06-10
[email protected]
9
61
Ines
Cox
1983-08-20
[email protected]
+ 100%
Close
