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
How many climbers are there?
assistant
SELECT count(*) FROM climber
human
What is the maximum point for climbers whose country is United Kingdom?
assistant
SELECT max(Points) FROM climber WHERE Country = 'United Kingdom'
human
What is the name of the highest mountain?
assistant
SELECT Name FROM mountain ORDER BY Height DESC LIMIT 1
human
List the names of climbers in descending order of points.
assistant
SELECT Name FROM climber ORDER BY Points DESC
human
What is the height of the mountain climbined by the climbing who had the most 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 ;