CREATE TABLE table_name_70 (date_of_vacancy VARCHAR2, manner_of_departure VARCHAR2, replaced_by VARCHAR2)

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