CREATE TABLE table_15803 ("Riding" TEXT, "Candidate's Name" TEXT, "Gender" TEXT, "Residence" TEXT, "Occupation" TEXT, "Votes" FLOAT, "Rank" TEXT)

What job is at red bank?
SELECT "Occupation" FROM table_15803 WHERE "Residence" = 'red bank'
SELECT "Occupation" FROM "table_15803" WHERE "Residence" = 'red bank'