CREATE TABLE table_name_47 (result VARCHAR2, date VARCHAR2)

What was the result of the game from 10 October 2009?
SELECT result FROM table_name_47 WHERE date = "10 october 2009"
SELECT "result" FROM "table_name_47" WHERE "10 october 2009" = "date"