Table: election_candidates_2008
Columns: riding
candidate
gender
residence
occupation
votes
rank

Question: What is the occupation of the candidate that resides in Windsor Junction?
SQL: SELECT "occupation" FROM election_candidates_2008 WHERE "residence" = 'windsor junction'

Question: How many votes did 3rd ranking candidate Mary Louise Lorefice receive?
SQL: SELECT COUNT("votes") FROM election_candidates_2008 WHERE "rank" = '3rd' AND "candidate" = 'mary louise lorefice'

Question: What occupation does Mary Louise Lorefice have?
SQL: SELECT "occupation" FROM election_candidates_2008 WHERE "candidate" = 'mary louise lorefice'