Show the unique occupation for the players?
select distinct occupation from player
How many in total?
select count(distinct occupation) from player
How many are there in each occupation?
select occupation, count(*) from player group by occupation