CREATE TABLE table_name_50 (team VARCHAR2, position_in_table VARCHAR2, date_of_appointment VARCHAR2)

what is the team with the position in table of 24th and the date of appointment 15 september 2008?
SELECT team FROM table_name_50 WHERE position_in_table = "24th" AND date_of_appointment = "15 september 2008"
SELECT "team" FROM "table_name_50" WHERE "15 september 2008" = "date_of_appointment" AND "24th" = "position_in_table"