Which Rank has a Gold of 3, and a Bronze of 4, and a Total larger than 8?
CREATE TABLE table_name_91 (rank INTEGER, total VARCHAR, gold VARCHAR, bronze VARCHAR)
SELECT MIN(rank) FROM table_name_91 WHERE gold = 3 AND bronze = 4 AND total > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_91 (rank INTEGER, total VARCHAR, gold VARCHAR, bronze VARCHAR) Question: Which Rank has a Gold of 3, and a Bronze of 4, and a Total larger than 8? [/INST] SELECT MIN(rank) FROM table_name_91 WHERE gold = 3 AND bronze = 4 AND total > 8 </s>