What are the countries that participated in both friendly and tournament type competitions?
SELECT country FROM competition WHERE competition_type  =  'Friendly' INTERSECT SELECT country FROM competition WHERE competition_type  =  'Tournament'
countries that participated in both refers to using INTERSECT between selections; friendly and tournament type competitions refers to competition_type = 'Friendly' and competition_type = 'Tournament';