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 countries are there?
assistant
SELECT COUNT( * ) FROM mountain;
human
How many mountains are there in Tanzania?
assistant
SELECT COUNT( * ) FROM mountain WHERE country = 'Tanzania';
human
What about in Uganda?
assistant
SELECT COUNT( * ) FROM mountain WHERE country = 'Uganda';
human
List the times used by the climbers for those mountains.
assistant
SELECT T1.Time FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID = T2.Mountain_ID WHERE T2.Country = "Uganda" ;