Back to missions

AnalystOS Mission / SQL

Find At-Risk Customers

Find which customers may leave and suggest one helpful action.

Difficulty

Intermediate

Estimated time

70-90 minutes

Reward

+100 XP

Role fit

Data Analyst / Data Scientist

Accept Mission

Mission Brief

What you need to solve

Find which customers may leave and suggest one helpful action.

Best fit

Data Analyst

Best fit

Data Scientist

Data You Will Use

What information you get

Customer groups, onboarding progress, revenue, and risk scores.

SQL basicsFinding patternsRisk explanationRecommendation writing

Guided Steps

Follow Step 1 to Step 5

Use these beginner-friendly steps before you accept the mission.

Step 1

Compare risk by customer group and region.

Step 2

Check where revenue has dropped.

Step 3

Name the clearest risk pattern.

Step 4

Suggest one action the team can measure.

Step 5

Save your work and explain your answer in simple language.

What You Will Create

What your work should contain

A short risk summary, a small evidence table, and one suggested action.

Working answer

Result table

Risk summary

Recommendation

Starter Question

Use this to begin

Which customers are most likely to leave, and what should the team try first?