Table: liberal_candidates_2008
Columns: riding
candidate_s_name
gender
residence
occupation
votes
rank

Question: The candidate with Riding of st. john's south—mount pearl is what gender?
SQL: SELECT "gender" FROM liberal_candidates_2008 WHERE "riding" = 'st. john''s south—mount pearl'

Question: What is the rank of walter noel from st. john's?
SQL: SELECT "rank" FROM liberal_candidates_2008 WHERE "residence" = 'st. john''s' AND "candidate_s_name" = 'walter noel'

Question: What is the name of the candidate from happy valley-goose bay with a gender of m?
SQL: SELECT "candidate_s_name" FROM liberal_candidates_2008 WHERE "gender" = 'm' AND "residence" = 'happy valley-goose bay'