What is the bronze when silver is 4 and gold is 1 and the total is more than 2
CREATE TABLE table_name_50 (bronze VARCHAR, silver VARCHAR, total VARCHAR, gold VARCHAR)
SELECT bronze FROM table_name_50 WHERE total > 2 AND gold = "1" AND silver = "4"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (bronze VARCHAR, silver VARCHAR, total VARCHAR, gold VARCHAR) Question: What is the bronze when silver is 4 and gold is 1 and the total is more than 2 [/INST] SELECT bronze FROM table_name_50 WHERE total > 2 AND gold = "1" AND silver = "4" </s>