I want the name for rank less than 6 and year more than 1974
CREATE TABLE table_name_75 (name VARCHAR, rank VARCHAR, year VARCHAR)
SELECT name FROM table_name_75 WHERE rank < 6 AND year > 1974
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_75 (name VARCHAR, rank VARCHAR, year VARCHAR) Question: I want the name for rank less than 6 and year more than 1974 [/INST] SELECT name FROM table_name_75 WHERE rank < 6 AND year > 1974 </s>