People AnalyticsHard
Compute promotion rate by manager, with enough sample size to trust it.
Seen at: Meta · Google · Microsoft
You have employees(emp_id, manager_id, hire_date, current_level, promoted_last_12mo). Write SQL that returns promotion rate by manager, but only for managers with at least 5 eligible direct reports, and highlights managers 1+ SD above or below the mean.
Draft your answer
Saved to this browser only. Try it before you peek at the model answer.
Reveals the model answer and the self-score rubric.