Table: manager_changes_8
Columns: team
outgoing_manager
manner_of_departure
date_of_vacancy
replaced_by
date_of_appointment

Question: Who is the Outgoing Manager replaced by Sandy Clark?
SQL: SELECT "outgoing_manager" FROM manager_changes_8 WHERE "replaced_by" = 'sandy clark'

Question: What is the Date of vacancy for Tommy McLean?
SQL: SELECT "date_of_vacancy" FROM manager_changes_8 WHERE "outgoing_manager" = 'tommy mclean'