>_BeginnerCoder
Donate

Lesson 25 — Ultimate: cohort report

Boss level: layered analytics

Combine a CTE, aggregation and CASE to bucket and count in one query.

Why it matters: cohort and funnel reports are prized SQL skills.

Task

Count users per age bucket.

Enjoying this lesson? Share it 👇

Keep going with SQL Deep Dive

Ready for more? These paid resources pick up where this lesson leaves off.

Some links on this page are affiliate links: we may earn a commission at no extra cost to you. We only recommend tools we believe are genuinely useful.