Table: manager_changes_07_08
Columns: team
outgoing_manager
manner_of_departure
date_of_vacancy
replaced_by
date_of_appointment

Question: What days is greenock morton vacant?
SQL: SELECT "date_of_vacancy" FROM manager_changes_07_08 WHERE "team" = 'Greenock Morton'

Question: What are the dates of the outgoing manager colin hendry does appointments? 
SQL: SELECT "date_of_appointment" FROM manager_changes_07_08 WHERE "outgoing_manager" = 'Colin Hendry'

Question: What teams does jim mcinally manage?
SQL: SELECT "team" FROM manager_changes_07_08 WHERE "outgoing_manager" = 'Jim McInally'

Question: What days are vacant that were replaced by john brown?
SQL: SELECT "date_of_vacancy" FROM manager_changes_07_08 WHERE "replaced_by" = 'John Brown'