Name the total number of total for bronze of 4 and silver more than 6
CREATE TABLE table_name_59 (total VARCHAR, bronze VARCHAR, silver VARCHAR)
SELECT COUNT(total) FROM table_name_59 WHERE bronze = 4 AND silver > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (total VARCHAR, bronze VARCHAR, silver VARCHAR) Question: Name the total number of total for bronze of 4 and silver more than 6 [/INST] SELECT COUNT(total) FROM table_name_59 WHERE bronze = 4 AND silver > 6 </s>