SQL Lab: Mobile Subscribers and Churn (synthetic)
About 3,500 invented mobile customers with monthly usage, billing, support tickets and churn over two years.
NovaMobile is an invented mobile operator with consumer, small-business and enterprise customers across eight regions. Management is worried about churn and wants to know which plans, channels and customer experiences predict customers leaving, and what that costs in monthly revenue. The data contains no names, phone numbers or addresses. Usage, billing and tickets are generated from a seeded script, with churn made more likely for month-to-month plans, heavy support users and some channels, so there are real patterns to find.
Write SQL on this sample data and see the results. It runs in your browser with SQLite, so it is not SQL Server, MySQL or PostgreSQL.