Table: drainage_basins
Columns: basin
outlet
total_area
in_state_area
in_state

Question: What outlet has and in-state area of 055 1,497km 2 578mi 2?
SQL: SELECT "outlet" FROM drainage_basins WHERE "in_state_area" = '055 1,497km 2 578mi 2'

Question: What is the total area of the Arkansas River outlet with a % in-state of a021 100%?
SQL: SELECT "total_area" FROM drainage_basins WHERE "outlet" = 'arkansas river' AND "in_state" = 'a021 100%'

Question: With an outlet of Colorado River and a % instate of a038 84.8% what is in-state area?
SQL: SELECT "in_state_area" FROM drainage_basins WHERE "outlet" = 'colorado river' AND "in_state" = 'a038 84.8%'

Question: What is the in-state area with an outlet of South Platte River and Big Thompson river as the basin?
SQL: SELECT "in_state_area" FROM drainage_basins WHERE "outlet" = 'south platte river' AND "basin" = 'big thompson river'

Question: With an in-state area of 053 1,654km 2 639mi 2, what is the total area?
SQL: SELECT "total_area" FROM drainage_basins WHERE "in_state_area" = '053 1,654km 2 639mi 2'

Question: What is the name of the basin with an in-state area of 071 238km 2 92mi 2?
SQL: SELECT "basin" FROM drainage_basins WHERE "in_state_area" = '071 238km 2 92mi 2'