Table: province_data
Columns: rank
common_of
population
area_km_2
density_inhabitants_km_2
altitude_mslm

Question: Which Altitude (mslm) has a Density (inhabitants/km 2) smaller than 1233, and a Rank of 9th?
SQL: SELECT SUM("altitude_mslm") FROM province_data WHERE "density_inhabitants_km_2" < 1233 AND "rank" = '9th'

Question: Which Altitude (mslm) has a Density (inhabitants/km 2) smaller than 1467.5, and a Common of moncalieri?
SQL: SELECT SUM("altitude_mslm") FROM province_data WHERE "density_inhabitants_km_2" < 1467.5 AND "common_of" = 'moncalieri'

Question: How much Area (km 2) has a Common of collegno, and a Population smaller than 50137?
SQL: SELECT COUNT("area_km_2") FROM province_data WHERE "common_of" = 'collegno' AND "population" < 50137

Question: How many people have an Altitude (mslm) larger than 302, and an Area (km 2) of 29.2?
SQL: SELECT COUNT("population") FROM province_data WHERE "altitude_mslm" > 302 AND "area_km_2" = 29.2

Question: Which Population is the highest one that has an Altitude (mslm) smaller than 229, and an Area (km 2) larger than 32.7?
SQL: SELECT MAX("population") FROM province_data WHERE "altitude_mslm" < 229 AND "area_km_2" > 32.7