Complex~35min

The Pay Gap That Only Shows Up At Promotion

30 Group-B employees promoted from L3 to L4 started at the same salary as their Group-A peers, got a smaller raise, and landed at a genuinely lower ending salary for the identical level jump — 896,000 versus 960,000. 10 more Group-B promotions also show a smaller percentage raise, but they started from an already-higher base and land at the exact same 960,000 ending salary as Group A.

Tables you'll query

employeespromotions

What you'll learn

CTEs (WITH clause)Window FunctionsAggregations & GROUP BY
Investigate this case →