Table: milan_cities
Columns: rank
city
population
area_km_2
density_inhabitants_km_2
altitude_mslm

Question: Which Population has an Altitude (mslm) larger than 98, and a Density (inhabitants/km 2) larger than 5869, and a Rank of 1st?
SQL: SELECT SUM("population") FROM milan_cities WHERE "altitude_mslm" > 98 AND "density_inhabitants_km_2" > 5869 AND "rank" = '1st'

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?
SQL: SELECT MAX("population") FROM milan_cities WHERE "density_inhabitants_km_2" > 2805.8 AND "rank" = '1st' AND "altitude_mslm" < 122

Question: Which Altitude (mslm) is the highest one that has an Area (km 2) smaller than 13.01, and a Population of 74536, and a Density (inhabitants/km 2) larger than 5869?
SQL: SELECT MAX("altitude_mslm") FROM milan_cities WHERE "area_km_2" < 13.01 AND "population" = 74536 AND "density_inhabitants_km_2" > 5869

Question: Which Altitude (mslm) is the highest one that has a City of legnano, and a Population larger than 59492?
SQL: SELECT MAX("altitude_mslm") FROM milan_cities WHERE "city" = 'legnano' AND "population" > 59492