Tenure at churn — how long do customers stay?

Nexus Financial Services · SQL · beginner

The brief

Marcus:

I want to understand the lifecycle. For customers who have churned, calculate their tenure (days from onboarding to churn). Then bucket the results:

- Under 6 months - 6-12 months - 1-2 years - 2+ years

For each bucket, show the count of churned customers and the percentage of total churns.

If most churn happens in the first 6 months, that points to onboarding quality. If it's evenly spread, it's probably about ongoing service.

Independent grading

92/100

Achieved 30 Oct 2026

Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.

What is DataSimHQ?

A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more