How many residences are there?
select count ( distinct residence ) from player
What are these residences?
select distinct residence from player
Which residences have more than 1 player?
select residence from player group by residence having count ( * ) > = 1