Table: clear_lake_oregon
Columns: name
type
elevation
usgs_map
gnis_id

Question: What type has a GNIS ID of 1139805
SQL: SELECT "type" FROM clear_lake_oregon WHERE "gnis_id" = 1139805

Question: Which name has a USGS Map of clear lake?
SQL: SELECT "name" FROM clear_lake_oregon WHERE "usgs_map" = 'clear lake'