Table: manager_changes_4
Columns: team
outgoing_manager
manner_of_departure
date_of_vacancy
replaced_by
date_of_appointment

Question: On which date was the manager fired and replaced by Albert Cartier?
SQL: SELECT "date_of_vacancy" FROM manager_changes_4 WHERE "manner_of_departure" = 'fired' AND "replaced_by" = 'albert cartier'

Question: What was the manner of departure for the team Anderlecht?
SQL: SELECT "manner_of_departure" FROM manager_changes_4 WHERE "team" = 'anderlecht'

Question: What was the manner of depature when the date of appointment was 27 December 2007?
SQL: SELECT "manner_of_departure" FROM manager_changes_4 WHERE "date_of_appointment" = '27 december 2007'

Question: Who was the replacement for the Brussels team with a date of vacancy of 22 December 2007?
SQL: SELECT "replaced_by" FROM manager_changes_4 WHERE "team" = 'brussels' AND "date_of_vacancy" = '22 december 2007'

Question: What was the date of vacancy where the replacement was Albert Cartier and the manager was fired?
SQL: SELECT "date_of_vacancy" FROM manager_changes_4 WHERE "manner_of_departure" = 'fired' AND "replaced_by" = 'albert cartier'