What about the most common type?
SELECT competition_type FROM competition GROUP BY competition_type ORDER BY COUNT ( * )  DESC LIMIT 1
most common type refers to mode (most frequent) of competition_type;