How many counties have 2 as the total, 0 as the city with a town less than 1?
CREATE TABLE "all_councils" (
  "party" text,
  "county" real,
  "city" real,
  "borough" real,
  "town" real,
  "total" real
);
SELECT SUM("county") FROM "all_councils" WHERE "total"=2 AND "city"=0 AND "town"<1;