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
Show the countries that have mountains with height more than 5600 stories and mountains with height less than 5200.
assistant
SELECT Country FROM mountain WHERE Height > 5600 INTERSECT SELECT Country FROM mountain WHERE Height < 5200
human
What are the names of mountains in ascending alphabetical order?
assistant
SELECT Name FROM mountain ORDER BY Name ASC
human
What is the name of the highest mountain?
assistant
SELECT Name FROM mountain ORDER BY Height DESC LIMIT 1
human
List the distinct ranges of the mountains with the top 3 prominence.
assistant
SELECT DISTINCT Range FROM mountain ORDER BY Prominence DESC LIMIT 3
human
What are the countries of mountains with height bigger than 5000?
assistant
SELECT Country FROM mountain WHERE Height > 5000
human
What are the names of mountains that have a height of over 5000 or a prominence of over 1000?
assistant
SELECT Name FROM mountain WHERE Height > 5000 OR Prominence > 1000 ;