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

Question: What is the geo ID for the township with 0.771 square miles of water?
SQL: SELECT MAX("geo_id") FROM townships_nd WHERE "water_sqmi" = '0.771'

Question: What is the geo id for Logan county?
SQL: SELECT MAX("geo_id") FROM townships_nd WHERE "county" = 'Logan'

Question: How big is the land in square miles of Grand Forks county?
SQL: SELECT "land_sqmi" FROM townships_nd WHERE "county" = 'Grand Forks'

Question: What is the geo id for Joliette?
SQL: SELECT MAX("geo_id") FROM townships_nd WHERE "township" = 'Joliette'

Question: What was the lattitude for the area with 4.243 square miles of water?
SQL: SELECT "latitude" FROM townships_nd WHERE "water_sqmi" = '4.243'

Question: What township is 28.597 square miles of land?
SQL: SELECT "township" FROM townships_nd WHERE "land_sqmi" = '28.597'