CREATE TABLE table_name_33 (date VARCHAR2, result VARCHAR2)

On what date was the Result 1-0?
SELECT date FROM table_name_33 WHERE result = "1-0"
SELECT "date" FROM "table_name_33" WHERE "1-0" = "result"