Which Altitude (mslm) is the highest one that has a City of legnano, and a Population larger than 59492?
CREATE TABLE table_name_47 (altitude__mslm_ INTEGER, city VARCHAR, population VARCHAR)
SELECT MAX(altitude__mslm_) FROM table_name_47 WHERE city = "legnano" AND population > 59492
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (altitude__mslm_ INTEGER, city VARCHAR, population VARCHAR) Question: Which Altitude (mslm) is the highest one that has a City of legnano, and a Population larger than 59492? [/INST] SELECT MAX(altitude__mslm_) FROM table_name_47 WHERE city = "legnano" AND population > 59492 </s>