Database: sports_competition
Question: which countries did participated in both Friendly and Tournament type competitions.
SQL:
SELECT country FROM competition WHERE competition_type  =  'Friendly' INTERSECT SELECT country FROM competition WHERE competition_type  =  'Tournament'