which countries did 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 participated in both Friendly and Tournament type competitions refers to using INTERSECT between competitions of type 'Friendly' and 'Tournament';