How many Totals have a CONCACAF of 0, and an MLS Cup smaller than 6?
CREATE TABLE table_name_64 (total VARCHAR, concacaf VARCHAR, mls_cup VARCHAR)
SELECT COUNT(total) FROM table_name_64 WHERE concacaf = 0 AND mls_cup < 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_64 (total VARCHAR, concacaf VARCHAR, mls_cup VARCHAR) Question: How many Totals have a CONCACAF of 0, and an MLS Cup smaller than 6? [/INST] SELECT COUNT(total) FROM table_name_64 WHERE concacaf = 0 AND mls_cup < 6 </s>