Which carpet has a Clay of 1–0 and a Hard 1–1?
CREATE TABLE table_name_1 (carpet VARCHAR, clay VARCHAR, hard VARCHAR)
SELECT carpet FROM table_name_1 WHERE clay = "1–0" AND hard = "1–1"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_1 (carpet VARCHAR, clay VARCHAR, hard VARCHAR) Question: Which carpet has a Clay of 1–0 and a Hard 1–1? [/INST] SELECT carpet FROM table_name_1 WHERE clay = "1–0" AND hard = "1–1" </s>