What is the total number for July with less than 8.05 in October, more than 4.46 in December, and more than 6.79 in November?
CREATE TABLE table_name_12 (july VARCHAR, november VARCHAR, october VARCHAR, december VARCHAR)
SELECT COUNT(july) FROM table_name_12 WHERE october < 8.05 AND december > 4.46 AND november > 6.79
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_12 (july VARCHAR, november VARCHAR, october VARCHAR, december VARCHAR) Question: What is the total number for July with less than 8.05 in October, more than 4.46 in December, and more than 6.79 in November? [/INST] SELECT COUNT(july) FROM table_name_12 WHERE october < 8.05 AND december > 4.46 AND november > 6.79 </s>