human
Schema:
swimmer (ID, name, Nationality, meter_100, meter_200, meter_300, meter_400, meter_500, meter_600, meter_700, Time)
stadium (ID, name, Capacity, City, Country, Opening_year)
event (ID, Name, Stadium_ID, Year)
record (ID, Result, Swimmer_ID, Event_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me the name of all stadiums.
assistant
SELECT Name FROM stadium;
human
What about their opening years?
assistant
SELECT Name , opening_year FROM stadium;
human
Only list those opened after 2006.
assistant
SELECT Name , opening_year FROM stadium WHERE opening_year > 2006;
human
Show me the countries which has any of those stadiums.
assistant
SELECT country FROM stadium WHERE opening_year > 2006 ;