What are all the residences?
select distinct residence from player
How many people live at each of them?
select residence, count ( * ) from player group by residence
Now remove the residences with less than 2 people
select residence, count ( * ) from player except select residence, count ( * ) from player where count ( * ) < 2
OK, now list all the people who live in Winnipeg and their gender.
select player_name, gender from player where residence = "Winnipeg"