Show me all the types of competitions?
select distinct ( competition_type ) from competition
show me the types of competition that have atleast five competition of that type
select competition_type from competition group by competition_type having count ( * ) > = 5
show me the types of competition that has at most competitions of that type
select competition_type from competition group by competition_type having count ( * ) < = 5