Before They Walk

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 retention team is convinced that most of the revenue on this book of business comes from a tiny sliver of the customer base, and they want to stand up a white-glove loyalty program aimed at exactly those people before a competitor poaches them. They have asked us to pull the ten customers who have contributed the most money across every purchase they have ever made, and to put a human-readable name next to each one so the team can actually reach out, with the biggest spenders shown first.

Summary

A few names carry the whole ledger. Reach them first, before someone else does.

Practice This Problem

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