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
what is the name of the countries that do not have a stadium that was opened after 2006?
assistant
SELECT country FROM stadium EXCEPT SELECT country FROM stadium WHERE opening_year > 2006;
human
what is the capacity for England? | You mean the stadium in England? | yes
assistant
SELECT capacity FROM stadium WHERE country = 'England';
human
in what city is the stadium in England?
assistant
SELECT city FROM stadium WHERE country = "England" ;