WHAT IS AN AVERAGE ELECTORATE WITH VOTES OF 28,475 AND SPOILT SMALLER THAN 5,779?
CREATE TABLE "plebiscite" (
  "constituency" text,
  "electorate" real,
  "votes" real,
  "turnout" real,
  "spoilt" real,
  "percent_yes" real
);
SELECT AVG("electorate") FROM "plebiscite" WHERE "votes"='28,475' AND "spoilt"<'5,779';