what are the name of the countries who have participated in both the friendly and tournament type competitions
select country from competition where competition_type = 'Friendly' intersect select country from competition where competition_type = 'Tournament'
list all the competition id for russia
select competition_id from competition where country = "Russia"
include the year in the table
select competition_id, year from competition where country = "Russia"