Table: liberal_election_2008
Columns: riding
candidate_s_name
gender
residence
occupation
votes
rank

Question: What job is at red bank?
SQL: SELECT "occupation" FROM liberal_election_2008 WHERE "residence" = 'red bank'