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 countries of the mountains.
assistant
SELECT Country FROM mountain;
human
Keep the ones that the mountain height is more than 4985.0.
assistant
SELECT Country FROM mountain WHERE Height > 4985.0;
human
What about the height is more than 5600?
assistant
SELECT Country FROM mountain WHERE Height > 5600;
human
Keep the country names where the mountain height is within the range of 5200 to 5600.
assistant
SELECT Country FROM mountain WHERE Height > 5600 INTERSECT SELECT Country FROM mountain WHERE Height < 5200 ;