When was the game played against Norway with a result of 1:0?
CREATE TABLE table_name_7 (date VARCHAR, opponent VARCHAR, results¹ VARCHAR)
SELECT date FROM table_name_7 WHERE opponent = "norway" AND results¹ = "1:0"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_7 (date VARCHAR, opponent VARCHAR, results¹ VARCHAR) Question: When was the game played against Norway with a result of 1:0? [/INST] SELECT date FROM table_name_7 WHERE opponent = "norway" AND results¹ = "1:0" </s>