What are the distinct years in which the competitions type is not "Tournament"?
CREATE TABLE competition (YEAR VARCHAR, Competition_type VARCHAR)
SELECT DISTINCT YEAR FROM competition WHERE Competition_type <> "Tournament"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE competition (YEAR VARCHAR, Competition_type VARCHAR) Question: What are the distinct years in which the competitions type is not "Tournament"? [/INST] SELECT DISTINCT YEAR FROM competition WHERE Competition_type <> "Tournament" </s>