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

Question: How many Votes, when the Residence is Halifax?
SQL: SELECT "votes" FROM election_candidates_2008_4 WHERE "residence" = 'halifax'

Question: What is the Riding, when the Rank is 4th?
SQL: SELECT "riding" FROM election_candidates_2008_4 WHERE "rank" = '4th'

Question: What is the lowest number of Votes, when the Candidate's Name is Trevor Ennis?
SQL: SELECT MIN("votes") FROM election_candidates_2008_4 WHERE "candidate_s_name" = 'trevor ennis'

Question: What is the Candidate's Name, when the Votes are 513?
SQL: SELECT "candidate_s_name" FROM election_candidates_2008_4 WHERE "votes" = 513

Question: What is the Occupation, when the Candidate's Name is Trevor Ennis?
SQL: SELECT "occupation" FROM election_candidates_2008_4 WHERE "candidate_s_name" = 'trevor ennis'