user: ### NOW ANSWER:
Question: What is the Occupation, when the Candidate's Name is Trevor Ennis?
Columns: ['Riding', "Candidate's Name", 'Gender', 'Residence', 'Occupation', 'Votes', 'Rank']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Central Nova', 'Michael Mackay', 'M', 'West River Station', 'Retail', 427.0, '4th']
SQL:

assistant: SELECT "Occupation" FROM "Table" WHERE "Candidate's Name" = 'Trevor Ennis';