Home result of 1–0, and a Away result of 0–1 involves what club?
CREATE TABLE table_name_56 (club VARCHAR, home_result VARCHAR, away_result VARCHAR)
SELECT club FROM table_name_56 WHERE home_result = "1–0" AND away_result = "0–1"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_56 (club VARCHAR, home_result VARCHAR, away_result VARCHAR) Question: Home result of 1–0, and a Away result of 0–1 involves what club? [/INST] SELECT club FROM table_name_56 WHERE home_result = "1–0" AND away_result = "0–1" </s>