CREATE TABLE table_24949975_1 (home_team VARCHAR, date VARCHAR)

Who as the home team for game on 5 october 2011?
SELECT home_team FROM table_24949975_1 WHERE date = "5 October 2011"
SELECT "home_team" FROM "table_24949975_1" WHERE "5 October 2011" = "date"