user: Question: What is John Marvin Wierenga's occupation?
Columns: ['Riding', "Candidate's Name", 'Gender', 'Residence', 'Occupation', 'Votes', 'Rank']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Calgary Southwest', 'Larry Heather', 'M', 'Calgary', 'Audio Producer', 256.0, '6th']
SQL:

assistant: SELECT "Occupation" FROM "Table" WHERE "Candidate's Name" = 'John Marvin Wierenga';