Count the total number of patients without any allergies (without_allergies) and the total number of patients with any allergies (with_allergies). If allergiesis NULL, the patient is considered to have no allergies. The result must be a single row.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Two counts in one row: one for NULL allergies and one for non-NULL. Remember that COUNT(column) ignores NULLs.