user: ### NOW ANSWER:
Question: On what date was the Result 1-0?
Columns: ['Date', 'Round', 'Opponent', 'Venue', 'Result', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'text', 'real']
Sample row: ['27 October 2004', 'R3', 'West Ham United', 'H', '1-0', 41774.0]
SQL:

assistant: SELECT "Date" FROM "Table" WHERE "Result" = '1-0';