Table: canada_cities_area
Columns: rank
municipality
province
status
area_km_2

Question: What Municipality has a Rank of 44?
SQL: SELECT "municipality" FROM canada_cities_area WHERE "rank" = 44

Question: What is the total Rank that has a Municipality of Winnipeg, an Area (KM 2) that's larger than 464.01?
SQL: SELECT SUM("rank") FROM canada_cities_area WHERE "municipality" = 'winnipeg' AND "area_km_2" > 464.01

Question: What is the highest Area (KM 2) for the Province of Ontario, that has the Status of Town, a Municipality of Minto, and a Rank that's smaller than 84?
SQL: SELECT MAX("area_km_2") FROM canada_cities_area WHERE "province" = 'ontario' AND "status" = 'town' AND "municipality" = 'minto' AND "rank" < 84

Question: What's the total of Rank that has an Area (KM 2) of 1050.14?
SQL: SELECT SUM("rank") FROM canada_cities_area WHERE "area_km_2" = 1050.14

Question: What is the listed Status that has the Province of Ontario and Rank of 86?
SQL: SELECT "status" FROM canada_cities_area WHERE "province" = 'ontario' AND "rank" = 86