The candidate with Riding of st. john's south—mount pearl is what gender?
CREATE TABLE table_name_3 (gender VARCHAR, riding VARCHAR)
SELECT gender FROM table_name_3 WHERE riding = "st. john's south—mount pearl"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_3 (gender VARCHAR, riding VARCHAR) Question: The candidate with Riding of st. john's south—mount pearl is what gender? [/INST] SELECT gender FROM table_name_3 WHERE riding = "st. john's south—mount pearl" </s>