What is the comp for the year 1989?
CREATE TABLE table_name_42 (comp VARCHAR, year VARCHAR)
SELECT comp FROM table_name_42 WHERE year = "1989"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (comp VARCHAR, year VARCHAR) Question: What is the comp for the year 1989? [/INST] SELECT comp FROM table_name_42 WHERE year = "1989" </s>