Assume each doctor has exactly one specialty. For each patient diagnosed with 'Hypertension' (a patient may have multiple such admissions), display each unique combination of (patient_id, first_name, last_name, attending doctor's specialty) exactly once. Order the result by patient_id ascending, then specialty ascending.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Follow the chain from patients to admissions to doctors, and filter on the diagnosis. You need join three tables.