Which Population is the highest one that has a Density (inhabitants/km 2) larger than 2805.8, and a Rank of 1st, and an Altitude (mslm) smaller than 122?
CREATE TABLE table_name_99 (population INTEGER, altitude__mslm_ VARCHAR, density__inhabitants_km_2__ VARCHAR, rank VARCHAR)
SELECT MAX(population) FROM table_name_99 WHERE density__inhabitants_km_2__ > 2805.8 AND rank = "1st" AND altitude__mslm_ < 122
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (population INTEGER, altitude__mslm_ VARCHAR, density__inhabitants_km_2__ VARCHAR, rank VARCHAR) Question: Which Population is the highest one that has a Density (inhabitants/km 2) larger than 2805.8, and a Rank of 1st, and an Altitude (mslm) smaller than 122? [/INST] SELECT MAX(population) FROM table_name_99 WHERE density__inhabitants_km_2__ > 2805.8 AND rank = "1st" AND altitude__mslm_ < 122 </s>