Show the player names and the residences.
select player_name, residence from player
Only keep those whose gender is male.
select player_name, residence from player where gender = "M"
Show the player names and the residences whose occupation is not "Researcher".
select player_name, residence from player where occupation != "Researcher"