What is the most common occupation of players?
select occupation from player group by occupation order by count ( * ) desc limit 1
What about least common?
select occupation from player group by occupation order by count ( * ) limit 1
yes
select player_name from player group by occupation order by count ( * ) limit 1
What about most common?
select player_name from player group by occupation order by count ( * ) desc limit 1
What is his sponsor name?
select sponsor_name from player group by occupation order by count ( * ) desc limit 1