Show the unique occupation for the players?
select distinct occupation from player
How many in total?
select count(distinct occupation) from player
Which is the most popular occupation?
select occupation from player group by occupation order by count(*) desc limit 1