The Ones Who Return

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

Domain

SQL

Difficulty

medium

Seniority

mid

Problem

Our member growth team is prepping the quarterly retention review and wants a single number for how top-heavy the buying really is: the members who shop more often than the average customer are the ones carrying the business. Counting every purchase as one order, give the share of the member base that makes more purchases than the average member, as a percentage rounded to two decimals.

Summary

One purchase is a trial. Two is a habit. Find how many members formed one.

Practice This Problem

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