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 is the name of the highest mountain?
assistant
SELECT Name FROM mountain ORDER BY Height DESC LIMIT 1
human
Show names of climbers and the names of mountains they climb.
assistant
SELECT T1.Name , T2.Name 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 names of climbers in descending order of points.
assistant
SELECT Name FROM climber ORDER BY Points DESC
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 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 ;