user: Question: How many counties have 2 as the total, 0 as the city with a town less than 1?
Columns: ['Party', 'County', 'City', 'Borough', 'Town', 'Total']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Fine Gael', 305.0, 35.0, 16.0, 200.0, 556.0]
SQL:

assistant: SELECT COUNT("County") FROM "Table" WHERE "Total" = 2.0 AND "City" = 0.0 AND "Town" < 1.0;