human
Schema:
club (Club_ID, name, Region, Start_year)
club_rank (Rank, Club_ID, Gold, Silver, Bronze, Total)
player (Player_ID, name, Position, Club_ID, Apps, Tries, Goals, Points)
competition (Competition_ID, Year, Competition_type, Country)
competition_result (Competition_ID, Club_ID_1, Club_ID_2, Score)
Please answer with SQL.
assistant
Sure, I understand.
human
what are the name of the countries who have participated in both the friendly and tournament type competitions
assistant
SELECT country FROM competition WHERE competition_type = 'Friendly' INTERSECT SELECT country FROM competition WHERE competition_type = 'Tournament';
human
what is the competition id of the country | Can you clarify? The competition id is not unique to a country. | list all the competition id for russia
assistant
SELECT Competition_ID FROM competition WHERE country = 'Russia';
human
include the year in the table
assistant
SELECT Competition_ID , year FROM competition WHERE country = "Russia" ;