user: Question: What is the naMe of the candidate froM Happy Valley-Goose Bay with a gender of M?
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 "Candidate's Name" FROM "Table" WHERE "Gender" = 'M' AND "Residence" = 'Happy Valley-Goose Bay';