How much Burnley has a Fylde smaller than 1, and a Rossendale larger than 0?
CREATE TABLE "summary_of_results_2009" (
  "party" text,
  "burnley" real,
  "chorley" real,
  "fylde" real,
  "hyndburn" real,
  "lancaster" real,
  "pendle" real,
  "preston" real,
  "ribble_valley" real,
  "rossendale" real,
  "south_ribble" real,
  "west_lancashire" real,
  "wyre" real,
  "total" real
);
SELECT SUM("burnley") FROM "summary_of_results_2009" WHERE "fylde"<1 AND "rossendale">0;