user: Question: The candidate with Riding of St. John's South—Mount Pearl is what gender?
Columns: ['Riding', "Candidate's Name", 'Gender', 'Residence', 'Occupation', 'Votes', 'Rank']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['Avalon', 'Scott Andrews', 'M', 'Conception Bay South', 'Municipal Councillor', 14866.0, '1st']
SQL:

assistant: SELECT "Gender" FROM "Table" WHERE "Riding" = 'St. John''s South—Mount Pearl';