How many counties have people before profit as the party, and a borough greater than 0?
CREATE TABLE "all_councils" (
  "party" text,
  "county" real,
  "city" real,
  "borough" real,
  "town" real,
  "total" real
);
SELECT SUM("county") FROM "all_councils" WHERE "party"='people before profit' AND "borough">0;