Verified by DataSimHQ

Analyst

Bashirat Oyekunle

Senior Analyst

Project

Patient age distribution

Vitalcore Health Network · SQL · beginner

The brief

Priya:

Help me understand who we are seeing. Pull a count of unique patients seen in 2024, grouped by age bucket: 0-17, 18-39, 40-64, 65+.

Use date_of_birth and the encounter_date to compute the patient's age at the time of visit. Count distinct patient_ids per bucket. Order by age bucket.

Independent grading

95/100

Achieved 27 Oct 2026

Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.

What is DataSimHQ?

A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more