When 142900 is the population what is the highest rank?
CREATE TABLE table_23248420_1 (rank INTEGER, population VARCHAR)
SELECT MAX(rank) FROM table_23248420_1 WHERE population = 142900
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_23248420_1 (rank INTEGER, population VARCHAR) Question: When 142900 is the population what is the highest rank? [/INST] SELECT MAX(rank) FROM table_23248420_1 WHERE population = 142900 </s>