how many new managers replaced  manager(s) who resigned?
create table table_28164986_4 (incoming_manager varchar, manner_of_departure varchar, PRIMARY KEY (incoming_manager))
select count(incoming_manager) from table_28164986_4 where manner_of_departure = "resigned"