Table: manager_changes_07_08
Columns: team
outgoing_manager
manner_of_departure
replaced_by
date_of_appointment

Question: I want the date of appointment for manner of departure being sacked
SQL: SELECT "date_of_appointment" FROM manager_changes_07_08 WHERE "manner_of_departure" = 'sacked'

Question: I want the manner of departure for 1 june 2007
SQL: SELECT "manner_of_departure" FROM manager_changes_07_08 WHERE "date_of_appointment" = '1 june 2007'

Question: I want the outgoing manager for craig brewster
SQL: SELECT "outgoing_manager" FROM manager_changes_07_08 WHERE "replaced_by" = 'craig brewster'

Question: I want the team for replaced by mark mcghee
SQL: SELECT "team" FROM manager_changes_07_08 WHERE "replaced_by" = 'mark mcghee'

Question: I want the outgoing manager for 19 february
SQL: SELECT "outgoing_manager" FROM manager_changes_07_08 WHERE "date_of_appointment" = '19 february'

Question: I want the team with replaced by being csaba lászló
SQL: SELECT "team" FROM manager_changes_07_08 WHERE "replaced_by" = 'csaba lászló'