SELECT Residence FROM player GROUP BY Residence HAVING COUNT(*)  >=  2
Show the residences that have at least two players.
SELECT Residence FROM player GROUP BY Residence HAVING COUNT ( * ) > = 2
select residence from player group by residence having count ( * ) > = value
Show the residences that have at least two players .