CREATE TABLE table_11207040_6 (team VARCHAR2, outgoing_manager VARCHAR2)

What teams does jim mcinally manage?
SELECT team FROM table_11207040_6 WHERE outgoing_manager = "Jim McInally"
SELECT "team" FROM "table_11207040_6" WHERE "Jim McInally" = "outgoing_manager"