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
List all the ranges of the mountains.
assistant
SELECT Range FROM mountain;
human
Order those results by Prominence in descending order.
assistant
SELECT DISTINCT Range FROM mountain ORDER BY Prominence DESC;
human
Which one is the top one?
assistant
SELECT DISTINCT Range FROM mountain ORDER BY Prominence DESC LIMIT 1;
human
What about top 3?
assistant
SELECT DISTINCT Range FROM mountain ORDER BY Prominence DESC LIMIT 3 ;