user: Question: How many votes did the Security Guard get?
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 SUM("Votes") FROM "Table" WHERE "Occupation" = 'Security Guard';