Rahmi Remote/Tasks
TASK · intermediate · 2 hours
Answer 3 business questions with 1 JOIN query
Join order and customer tables to answer revenue questions
01
Why it matters
JOIN plus GROUP BY is 80 percent of daily analyst work and what interviews test.
02
Steps
- Get a sample dataset (orders plus customers, or make 50 rows)
- JOIN both tables on customer_id
- Compute revenue per customer last month (GROUP BY plus SUM)
- Show top 10 plus average order
- Write 3 lines of insight in human language
03
Expected output
Query .sql plus result table plus 3 insights
04
Checklist
- JOIN key correct (check duplicates)
- Numbers pass sanity checks
- Insights cite specific numbers
05
Evidence
Commented SQL file plus result screenshot
06
Self review
Would your query still be correct at 10x the data?
NEXT TASKS
TOOLS USED
STUCK OR UNSURE?
bring your learning to a 1-on-1All materials are free to study. If positioning, portfolio, or apply strategy stalls, we dissect it together.