Count the patients without allergies and the patients with any allergy. Return two columns (Has_Allergies, Total_patients) and two rows labelled 'Yes' and 'No'. (allergiesIS NULL means the patient has no allergies). The displayed results must match the expected output in terms of column names and order.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Turn the allergy column into a Yes/No label first, then group by that label.