Same as question 23, but add total_diagnosis column showing the number of distinct diagnoses of each patient. Column names and their order must match the expected output.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Counting rows is not the same as counting different diagnoses. Put DISTINCT inside the COUNT.