Everyone Counts

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The growth team is profiling the whole user base by age, and plenty of accounts still have no age on file. Show each age bucket that holds more than one user along with its user count, most populated first, and count the accounts with no bucket recorded as a segment of their own.

Summary

Every account lands in a segment, even the ones with nothing on file.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.