CREATE TABLE competition (Competition_type VARCHAR)

List the types of competition and the number of competitions of each type.
SELECT Competition_type, COUNT(*) FROM competition GROUP BY Competition_type
SELECT "Competition_type", COUNT(*) FROM "competition" GROUP BY "Competition_type"