CREATE TABLE player (Sponsor_name VARCHAR2, Residence VARCHAR2)

Show the names of sponsors of players whose residence is either 'Brandon' or 'Birtle'.
SELECT Sponsor_name FROM player WHERE Residence = "Brandon" OR Residence = "Birtle"
SELECT "Sponsor_name" FROM "player" WHERE "Birtle" = "Residence" OR "Brandon" = "Residence"