Table: ohio_river_locks
Columns: locks_dam
location_l
river_mile
lock_side
lock_lift_drop_in_feet
pool_length_miles

Question: What is the total of the River Mile in Greenup, Kentucky?
SQL: SELECT SUM("river_mile") FROM ohio_river_locks WHERE "location_l" = 'greenup, kentucky'

Question: What is the River Mile with a RDB lock side and a pool length of 55.4?
SQL: SELECT "river_mile" FROM ohio_river_locks WHERE "lock_side" = 'rdb' AND "pool_length_miles" = '55.4'

Question: What is the highest River Mile that has a pool length of 42.2 miles or a lock/lift drop of 21 feet?
SQL: SELECT MAX("river_mile") FROM ohio_river_locks WHERE "pool_length_miles" = '42.2' AND "lock_lift_drop_in_feet" = '21'

Question: What is the location of the river mile that is larger than 938.9, and Olmsted Locks and Dam?
SQL: SELECT "location_l" FROM ohio_river_locks WHERE "river_mile" > 938.9 AND "locks_dam" = 'olmsted locks and dam'