What Gold has a Silver greater than 30 and a Total less than 107?
CREATE TABLE table_name_40 (gold VARCHAR, silver VARCHAR, total VARCHAR)
SELECT gold FROM table_name_40 WHERE silver > 30 AND total < 107
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (gold VARCHAR, silver VARCHAR, total VARCHAR) Question: What Gold has a Silver greater than 30 and a Total less than 107? [/INST] SELECT gold FROM table_name_40 WHERE silver > 30 AND total < 107 </s>