how many new managers replaced  manager(s) who resigned? 
CREATE TABLE table_28164986_4 (incoming_manager VARCHAR, manner_of_departure VARCHAR)
SELECT COUNT(incoming_manager) FROM table_28164986_4 WHERE manner_of_departure = "Resigned"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28164986_4 (incoming_manager VARCHAR, manner_of_departure VARCHAR) Question: how many new managers replaced  manager(s) who resigned?  [/INST] SELECT COUNT(incoming_manager) FROM table_28164986_4 WHERE manner_of_departure = "Resigned" </s>