Table: townships_north_dakota_4
Columns: township
county
pop_2010
land_sqmi
water_sqmi
latitude
longitude
geo_id
ansi_code

Question: what is the average water sqmi with a population (2010) more than 47 in the Brenna Township with Longitude less than -97.171507
SQL: SELECT AVG("water_sqmi") FROM townships_north_dakota_4 WHERE "pop_2010" > 47 AND "township" = 'brenna' AND "longitude" < -97.171507

Question: what is the latitude for the berlin township with a geo id less than 3801706260
SQL: SELECT COUNT("latitude") FROM townships_north_dakota_4 WHERE "township" = 'berlin' AND "geo_id" < 3801706260

Question: what is the highest ANSI code with a latitude more than 47.623288 and a geo id more than 3805508060 with land (sqmi) more than 35.66 and a longitude less than -102.054248
SQL: SELECT MAX("ansi_code") FROM townships_north_dakota_4 WHERE "latitude" > 47.623288 AND "geo_id" > 3805508060 AND "land_sqmi" > 35.66 AND "longitude" < -102.054248

Question: what is the lowest latitude for the land sqmi less than 32.696 and a water sqmi less than 0
SQL: SELECT MIN("latitude") FROM townships_north_dakota_4 WHERE "land_sqmi" < 32.696 AND "water_sqmi" < 0