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 countries of mountains with height bigger than 5000?
assistant
SELECT Country FROM mountain WHERE Height > 5000
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
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
human
Show the height of the mountain climbed by the climber with the maximum points.
assistant
SELECT T2.Height FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID = T2.Mountain_ID ORDER BY T1.Points DESC LIMIT 1
human
Return the name of the mountain with the greatest height.
assistant
SELECT Name FROM mountain ORDER BY Height DESC LIMIT 1 ;