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
How many mountains in this table?
assistant
SELECT COUNT( * ) FROM mountain;
human
Show the distinct names of mountains climbed by climbers from country 'West Germany'.
assistant
SELECT DISTINCT T2.Name FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID = T2.Mountain_ID WHERE T1.Country = 'West Germany';
human
Please show me the name of the highest mountain.
assistant
SELECT Name FROM mountain ORDER by Height desc LIMIT 1 ;