Assume that each patient has either a single allergy or no allergies. List all allergies, sorted by popularity (excluding cases with no allergies). For allergies with the same number of cases, sort alphabetically by allergy name; column names and 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
Count each allergy and order by that count. Think about what should happen with NULL allergies.