How many competitions are there where the competition type is 'Friendly'?
select count(*) from competition where competition_type = 'Friendly'
What about for the type 'Tournament'?
select count(*) from competition where competition_type = 'Tournament'
Among those results, how many competitions are there for each country?
select country from competition where competition_type = 'Tournament' group by country
Which one is the most popular country?
select country from competition where competition_type = 'Tournament' group by country order by count(*) desc limit 1