CREATE TABLE table_28164986_4 (incoming_manager VARCHAR, manner_of_departure VARCHAR)

how many new managers replaced manager(s) who resigned?
SELECT COUNT(incoming_manager) FROM table_28164986_4 WHERE manner_of_departure = "Resigned"
SELECT COUNT("incoming_manager") FROM "table_28164986_4" WHERE "Resigned" = "manner_of_departure"