Who is the opponent when there is a win in round greater than 1 and the record is 42-27-10?
CREATE TABLE table_name_23 (opponent VARCHAR, record VARCHAR, res VARCHAR, round VARCHAR)
SELECT opponent FROM table_name_23 WHERE res = "win" AND round > 1 AND record = "42-27-10"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (opponent VARCHAR, record VARCHAR, res VARCHAR, round VARCHAR) Question: Who is the opponent when there is a win in round greater than 1 and the record is 42-27-10? [/INST] SELECT opponent FROM table_name_23 WHERE res = "win" AND round > 1 AND record = "42-27-10" </s>