Loading...

Activity Histogram

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

Domain
SQL
Difficulty
easy
Seniority
junior

Problem

Retention modeling suspects the platform has a bimodal usage pattern: a cluster of one-and-done visitors and a cluster of heavy regulars with little in between. Build a histogram of session counts so the team can see how many users fall at each level of activity, from lowest to highest.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.