Complex~39min
The Attrition Cohort That Isn't Random
The 2023-06 hire cohort — every one of them managed by MGR-007 — has only 40% voluntary retention at 12 months, versus ~90% for every neighboring cohort, and the departures start as early as month 2. The 2023-03 cohort also looks bad at 60% retention, but 6 of its 8 departures are tagged as layoffs from a company-wide restructuring, not voluntary attrition — filtering to voluntary-only clears it back to 90%.
Tables you'll query
employeesresignations
What you'll learn
CTEs (WITH clause)Window FunctionsCohort Analysis