which countries did participated in both Friendly and Tournament type competitions.
create table competition (country varchar, competition_type varchar, PRIMARY KEY (country))
select country from competition where competition_type = 'friendly' intersect select country from competition where competition_type = 'tournament'