CREATE TABLE table_name_45 (team VARCHAR2, outgoing_manager VARCHAR2)

Which team had Christoph John as an outgoing manager?
SELECT team FROM table_name_45 WHERE outgoing_manager = "christoph john"
SELECT "team" FROM "table_name_45" WHERE "christoph john" = "outgoing_manager"