Which Total has a Silver larger than 8, and a Bronze of 20, and a Gold smaller than 20?
CREATE TABLE table_name_93 (total VARCHAR, gold VARCHAR, silver VARCHAR, bronze VARCHAR)
SELECT COUNT(total) FROM table_name_93 WHERE silver > 8 AND bronze = 20 AND gold < 20
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_93 (total VARCHAR, gold VARCHAR, silver VARCHAR, bronze VARCHAR) Question: Which Total has a Silver larger than 8, and a Bronze of 20, and a Gold smaller than 20? [/INST] SELECT COUNT(total) FROM table_name_93 WHERE silver > 8 AND bronze = 20 AND gold < 20 </s>