Show the player names and the residences.
select player_name, residence from player
Show the names and the occupation of each them.
select gender, occupation from player