And how many of those six distinct residences have More than one player?
select count ( * )  from  ( SELECT * FROM player GROUP BY Residence HAVING COUNT ( * )  > 1 ) 
More than one player refers to COUNT(*) > 1; six distinct residences implies filtering or considering unique residences;