Display patient information (patient_id, first_name, last_name, admission_date) and the specialty of the doctor who saw them. Only show patients diagnosed with 'Pneumonia' from '2021' up to today whose doctor has the first_name'John'. The displayed list is sorted by patient_id, admission_date in ascending order.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Filter on the diagnosis in one table and on the doctor's first name in another.