user: Question: What job is at Red Bank?
Columns: ['Riding', "Candidate's Name", 'Gender', 'Residence', 'Occupation', 'Votes', 'Rank']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Acadie—Bathurst', 'Odette Robichaud', 'F', 'Inkerman Ferry', 'Stenographer', 9850.0, '2nd']
SQL:

assistant: SELECT "Occupation" FROM "Table" WHERE "Residence" = 'Red Bank';