Which Rank is the lowest one that has Points larger than 52, and a Year larger than 1970?
CREATE TABLE table_name_9 (rank INTEGER, points VARCHAR, year VARCHAR)
SELECT MIN(rank) FROM table_name_9 WHERE points > 52 AND year > 1970
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (rank INTEGER, points VARCHAR, year VARCHAR) Question: Which Rank is the lowest one that has Points larger than 52, and a Year larger than 1970? [/INST] SELECT MIN(rank) FROM table_name_9 WHERE points > 52 AND year > 1970 </s>