CREATE TABLE table_name_96 (date_of_appointment VARCHAR2, team VARCHAR2)

What date was Dundee appointed?
SELECT date_of_appointment FROM table_name_96 WHERE team = "dundee"
SELECT "date_of_appointment" FROM "table_name_96" WHERE "dundee" = "team"