Table: diamond_lakes_list
Columns: name
gnis_feature_id
state
county
type
usgs_7_5_map

Question: Which name has a type of lake, a County of hennepin, and a USGS 7.5 Map of rogers?
SQL: SELECT "name" FROM diamond_lakes_list WHERE "type" = 'lake' AND "county" = 'hennepin' AND "usgs_7_5_map" = 'rogers'

Question: What is the total GNIS Feature ID with a County of idaho?
SQL: SELECT SUM("gnis_feature_id") FROM diamond_lakes_list WHERE "county" = 'idaho'

Question: What is the lowest GNIS Feature ID from County of sheridan?
SQL: SELECT MIN("gnis_feature_id") FROM diamond_lakes_list WHERE "county" = 'sheridan'

Question: Which state has a GNIS Feature ID larger than 624634, and a USGS 7.5 Map of temple peak?
SQL: SELECT "state" FROM diamond_lakes_list WHERE "gnis_feature_id" > 624634 AND "usgs_7_5_map" = 'temple peak'

Question: Which state has a Name of diamond lake, and a GNIS Feature ID of 1579127?
SQL: SELECT "state" FROM diamond_lakes_list WHERE "name" = 'diamond lake' AND "gnis_feature_id" = 1579127