Table: manager_changes_98_99
Columns: team
outgoing_manager
manner_of_departure
date_of_vacancy
replaced_by
date_of_appointment

Question: What is Aberdeen team's date of vacancy?
SQL: SELECT "date_of_vacancy" FROM manager_changes_98_99 WHERE "team" = 'aberdeen'

Question: What is Motherwell Team's manner of departure?
SQL: SELECT "manner_of_departure" FROM manager_changes_98_99 WHERE "team" = 'motherwell'

Question: What is the date of appointment for the team with a resigned manner of departure and replaced by Sandy Clark?
SQL: SELECT "date_of_appointment" FROM manager_changes_98_99 WHERE "manner_of_departure" = 'resigned' AND "replaced_by" = 'sandy clark'

Question: What manner of departure was Dick Advocaat replaced by?
SQL: SELECT "manner_of_departure" FROM manager_changes_98_99 WHERE "replaced_by" = 'dick advocaat'