What are the residences of the players?
select residence from player
Which of those residences have both male and female players?
select residence from player where gender = "M" intersect select residence from player where gender = "F"
How many male players does Winnipeg have?
select count ( * ) from player where gender = "M" and residence = "Winnipeg"
How many female players does Winnipeg have?
select count ( * ) from player where gender = "F" and residence = "Winnipeg"
How many residences are there in total?
select count ( distinct residence ) from player
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 )
Which residence is the one with more than one player?
select residence from player group by residence having count ( * ) > 1