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 names of climbers and the heights of mountains they climb.
assistant
SELECT T1.Name , T2.Height FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID = T2.Mountain_ID
human
Show the range that has the most number of mountains.
assistant
SELECT Range FROM mountain GROUP BY Range ORDER BY COUNT(*) 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
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
Show the names of mountains with height more than 5000 or prominence more than 1000.
assistant
SELECT Name FROM mountain WHERE Height > 5000 OR Prominence > 1000 ;