AnalystOS Mission / SQL
Combine Two Tables
Combine simple customer and order tables to find where money is being lost.
Difficulty
Beginner
Estimated time
45-60 minutes
Reward
+50 XP
Role fit
Data Analyst / Business Analyst
Mission Brief
What you need to solve
Combine simple customer and order tables to find where money is being lost.
Best fit
Data Analyst
Best fit
Business Analyst
Data You Will Use
What information you get
Customer orders, refunds, customer groups, and revenue fields.
Guided Steps
Follow Step 1 to Step 5
Use these beginner-friendly steps before you accept the mission.
Read the question and identify the tables you need.
Connect the customer and revenue information.
Group the results by customer type or region.
Write three simple sentences explaining what you found.
Save your work and explain your answer in simple language.
What You Will Create
What your work should contain
A working answer, a small results table, and three plain sentences about what to fix first.
Working answer
Result table
Three-sentence explanation
Starter Question
Use this to begin
Find the customer group losing the most money and explain what the team should do next.