List the types of competition and the number of competitions of each type.
CREATE TABLE competition (Competition_type VARCHAR)
[SQL] SELECT Competition_type, COUNT(*) FROM competition GROUP BY Competition_type [/SQL]