SELECT Competition_type ,  COUNT(*) FROM competition GROUP BY Competition_type
What are the types of competition and number of competitions for that type?
SELECT Competition_type , COUNT ( * ) FROM competition GROUP BY Competition_type
select competition_type , count ( * ) from competition group by competition_type
What are the types of competition and number of competitions for that type ?