69

Patient Age Groups

MediumCASEGROUP BY

Problem Description

Write a SQL query to count patients in different age groups: Under 40, 40-55, Over 55.

Expected Columns

  • age_group
  • patient_count

Example Output

| age_group | patient_count | |-----------|---------------| | Under 40 | 5 | | 40-55 | 5 | | Over 55 | 2 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#69 Patient Age Groups
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results