What average city has a total less than 2, with a borough greater than 0?
CREATE TABLE "all_councils" (
  "party" text,
  "county" real,
  "city" real,
  "borough" real,
  "town" real,
  "total" real
);
SELECT AVG("city") FROM "all_councils" WHERE "total"<2 AND "borough">0;