List the name and the sponsor name of each player.
select player_name, sponsor_name from player
How many unique sponsor names are there?
select count(distinct sponsor_name) from player
Which sponsor names support female players?
select sponsor_name from player where gender = "F"
What about supporting players whose residence is "Brandon" or "Birtle"?
select sponsor_name from player where residence = "Brandon" or residence = "Birtle"