Display (patient_id, diagnosis) for the two patients with IDs 5 and 11. List all distinct diagnoses of each of these patients, with the diagnoses of each patient collected into a single row.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Aggregate per patient, and make sure repeated diagnoses appear only once inside the string.