What are the types of competition and number of competitions for that type?
select competition_type, count(*) from competition group by competition_type