How many unique competition types are there?
select count (distinct competition_type) from competition
How many competitions are there for each type?
select competition_type, count(*) from competition group by competition_type
Among those results, which one is the most common one?
select competition_type from competition group by competition_type order by count(*) desc limit 1