When was the score 1–0, and the result  4–0?
CREATE TABLE table_name_67 (date VARCHAR, score VARCHAR, result VARCHAR)
SELECT date FROM table_name_67 WHERE score = "1–0" AND result = "4–0"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_67 (date VARCHAR, score VARCHAR, result VARCHAR) Question: When was the score 1–0, and the result  4–0? [/INST] SELECT date FROM table_name_67 WHERE score = "1–0" AND result = "4–0" </s>