Can you tell me total number of Silver that has the Republic of latvian ssr, and the Total larger than 6?
CREATE TABLE table_name_12 (silver VARCHAR, republic VARCHAR, total VARCHAR)
SELECT COUNT(silver) FROM table_name_12 WHERE republic = "latvian ssr" AND total > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_12 (silver VARCHAR, republic VARCHAR, total VARCHAR) Question: Can you tell me total number of Silver that has the Republic of latvian ssr, and the Total larger than 6? [/INST] SELECT COUNT(silver) FROM table_name_12 WHERE republic = "latvian ssr" AND total > 6 </s>