Beginner · 20 min · 5 steps
Who earns more than their boss, and which rows go missing?
Pooja Nambiar, People Analytics Engineering Specialist at NexaTech Solutions
It is Thursday, 2:30 PM. Pooja Nambiar works with people data at NexaTech Solutions, a software company with over 450 engineers in Bengaluru and Pune. She has been called to a private meeting with the head of HR and the pay committee. The company is doing its yearly pay review before promotions.
The question
Which employees earn more than their manager, and which rows does the join quietly leave out?
- Self join
- Aliases
- NULL handling
- GROUP BY
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.