Tell me the total number of gold for bronze more than 0 and total more than 100
CREATE TABLE table_name_2 (gold VARCHAR, bronze VARCHAR, rank VARCHAR)
SELECT COUNT(gold) FROM table_name_2 WHERE bronze > 0 AND rank = "total" AND "total" > 100
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (gold VARCHAR, bronze VARCHAR, rank VARCHAR) Question: Tell me the total number of gold for bronze more than 0 and total more than 100 [/INST] SELECT COUNT(gold) FROM table_name_2 WHERE bronze > 0 AND rank = "total" AND "total" > 100 </s>