How many golds were there in a game that has 17 bronze and a total of 31?
CREATE TABLE table_name_8 (gold VARCHAR, bronze VARCHAR, total VARCHAR)
SELECT gold FROM table_name_8 WHERE bronze = "17" AND total = "31"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (gold VARCHAR, bronze VARCHAR, total VARCHAR) Question: How many golds were there in a game that has 17 bronze and a total of 31? [/INST] SELECT gold FROM table_name_8 WHERE bronze = "17" AND total = "31" </s>