user: ### NOW ANSWER:
Question: How many Totals have a CONCACAF of 0, and an MLS Cup smaller than 6?
Columns: ['Name', 'Years', 'MLS Cup', 'U.S. Open Cup', 'CONCACAF', 'Other', 'Total']
Types: ['text', 'text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Wade Barrett', '2006–present', 8.0, 2.0, 5.0, 9.0, 86.0]
SQL:

assistant: SELECT COUNT("Total") FROM "Table" WHERE "CONCACAF" = 0.0 AND "MLS Cup" < 6.0;