What are the number of the positions for each type?
select position, count(*) from match_season group by position
Among those, which one is the list popular one?
select position from match_season group by position order by count(*) asc limit 1
How about the most popular one?
select position from match_season group by position order by count(*) desc limit 1