human
Schema:
state (state_name, population, area, country_name, capital, density)
city (city_name, population, country_name, state_name)
border_info (state_name, border)
highlow (state_name, highest_elevation, lowest_point, highest_point, lowest_elevation)
lake (lake_name, area, country_name, state_name)
mountain (mountain_name, mountain_altitude, country_name, state_name)
river (river_name, length, country_name, traverse)
Please answer with SQL.
assistant
Sure, I understand.
human
how many states have major rivers
assistant
SELECT COUNT ( traverse ) FROM river WHERE LENGTH > 750;
human
what are the major rivers in the us
assistant
SELECT river_name FROM river;
human
name the major lakes in michigan
assistant
SELECT lake_name FROM lake WHERE area > 750 AND state_name = 'michigan';
human
give me the lakes in california
assistant
SELECT lake_name FROM lake WHERE state_name = 'california';
human
name all the lakes of us
assistant
SELECT lake_name FROM lake;
human
show me all the major lakes in the us
assistant
SELECT lake_name FROM lake WHERE area > 750 ;