user: ### NOW ANSWER:
Question: What is the occupation of the candidate that resides in Windsor Junction?
Columns: ['Riding', 'Candidate', 'Gender', 'Residence', 'Occupation', 'Votes', 'Rank']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Cape Breton—Canso', 'Mark MacNeill', 'M', 'Inverness', 'Government and Business Policy Advisor', 7660.0, '3rd']
SQL:

assistant: SELECT "Occupation" FROM "Table" WHERE "Residence" = 'Windsor Junction';