user: ### NOW ANSWER:
Question: Who was the outgoing manager of the Heart of Midlothian?
Columns: ['Team', 'Outgoing manager', 'Manner of departure', 'Date of vacancy', 'Replaced by', 'Date of appointment']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Albion Rovers', 'John McCormack', 'Resigned', '28 June', 'Paul Martin', '9 July']
SQL:

assistant: SELECT "Outgoing manager" FROM "Table" WHERE "Team" = 'Heart of Midlothian';