Table: bundesliga_manager_changes
Columns: team
outgoing_manager
manner_of_departure
date_of_vacancy
position_in_table
replaced_by
date_of_appointment

Question: When steve mcclaren is the replacer what is the manner of departure?
SQL: SELECT "manner_of_departure" FROM bundesliga_manager_changes WHERE "replaced_by" = 'Steve McClaren'

Question: When 1. fc köln is the team what is the date of appointment?
SQL: SELECT "date_of_appointment" FROM bundesliga_manager_changes WHERE "team" = '1. FC Köln'