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 all the information about the mountains.
assistant
SELECT * FROM mountain;
human
List those results in ascending alphabetical order by the mountain names.
assistant
SELECT * FROM mountain ORDER BY Name ASC;
human
What are the mountain names from those results?
assistant
SELECT Name FROM mountain ORDER BY Name ASC ;