Show the unique residences for the players?
select distinct residence from player
How many in total?
select count(distinct residence) from player
Which residences have only one player?
select residence from player group by residence having count(*) = 1
What about at least two?
select residence from player group by residence having count(*) >= 2