When has a Record of 9–1, and a Tournament Champion of duke?
CREATE TABLE table_name_50 (year VARCHAR, record VARCHAR, tournament_champion VARCHAR)
SELECT year FROM table_name_50 WHERE record = "9–1" AND tournament_champion = "duke"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (year VARCHAR, record VARCHAR, tournament_champion VARCHAR) Question: When has a Record of 9–1, and a Tournament Champion of duke? [/INST] SELECT year FROM table_name_50 WHERE record = "9–1" AND tournament_champion = "duke" </s>