How many male players does Winnipeg have?
SELECT count ( * )  FROM player where gender  =  "M" and residence  =  "Winnipeg"
counting male players = count(*) WHERE gender = 'M'; players from Winnipeg = residence = 'Winnipeg';