Picture 3.1
Question 4:
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:
4 of 4
Paper No: 6
PatientID
FirstName LastName
DateOfBirth Email
1992-12-05
[email protected]
Rodriguez
1989-03-30
[email protected]
1
4
2
12
Diana
Lily
Taylor
3 17
Quincy
4
22
Vera
5
39
Mia
6
41
Owen
7
51
Yasmine
8 53
Anna
9
61
Ines
10 69
Rosa
+ 100%
1990-01-02
[email protected]
1990-03-22
[email protected]
1982-08-21
[email protected]
1985-01-15
[email protected]
1985-01-15
[email protected]
Chapman
1988-06-10
[email protected]
1983-08-20
[email protected]
1982-08-21
[email protected]
Zoom FUD
Close
