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

Question: How many votes did the security guard get?
SQL: SELECT "votes" FROM election_candidates_2008_3 WHERE "occupation" = 'security guard'

Question: What is John Marvin Wierenga's occupation?
SQL: SELECT "occupation" FROM election_candidates_2008_3 WHERE "candidate_s_name" = 'john marvin wierenga'