user: ### NOW ANSWER:
Question: What occupation does Mary Louise Lorefice have?
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 "Candidate" = 'Mary Louise Lorefice';