What is the total gold that has bronze less than 2, a silver of 1 and total more than 4?
CREATE TABLE table_name_32 (gold INTEGER, total VARCHAR, bronze VARCHAR, silver VARCHAR)
SELECT SUM(gold) FROM table_name_32 WHERE bronze < 2 AND silver = 1 AND total > 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_32 (gold INTEGER, total VARCHAR, bronze VARCHAR, silver VARCHAR) Question: What is the total gold that has bronze less than 2, a silver of 1 and total more than 4? [/INST] SELECT SUM(gold) FROM table_name_32 WHERE bronze < 2 AND silver = 1 AND total > 4 </s>