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

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