Activity Histogram

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

Domain

SQL

Difficulty

easy

Seniority

L3

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.

Summary

How many users did X things? Build the distribution.

Practice This Problem

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