SQL Query Update: Using CTE to Correctly Calculate OverStaffed Values

Replacing Values with Row Names in R: A Comparative Analysis of dplyr and Base R Solutions