What are the types of competition and number of competitions for that type?
SELECT Competition_type ,  COUNT(*) FROM competition GROUP BY Competition_type
types of competition refers to Competition_type; number of competitions for that type refers to COUNT(*) GROUP BY Competition_type;