human
Schema:
mountain (Mountain_ID, Name, Height, Prominence, Range, Country)
climber (Climber_ID, Name, Country, Time, Points, Mountain_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the names of mountains in the area?
assistant
SELECT Name FROM mountain;
human
How many of these have a height above 5000?
assistant
SELECT COUNT( Name ) FROM mountain WHERE Height > 5000;
human
What are the names of these mountains?
assistant
SELECT name FROM mountain WHERE Height > 5000 ;