When is the Competition of friendly match with a Result of 2–1?
CREATE TABLE table_name_47 (date VARCHAR, competition VARCHAR, result VARCHAR)
SELECT date FROM table_name_47 WHERE competition = "friendly match" AND result = "2–1"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (date VARCHAR, competition VARCHAR, result VARCHAR) Question: When is the Competition of friendly match with a Result of 2–1? [/INST] SELECT date FROM table_name_47 WHERE competition = "friendly match" AND result = "2–1" </s>