CREATE TABLE table_65584 ("Party" CLOB, "Burnley" FLOAT, "Chorley" FLOAT, "Fylde" FLOAT, "Hyndburn" FLOAT, "Lancaster" FLOAT, "Pendle" FLOAT, "Preston" FLOAT, "Ribble Valley" FLOAT, "Rossendale" FLOAT, "South Ribble" FLOAT, "West Lancashire" FLOAT, "Wyre" FLOAT, "Total" FLOAT)

How much Burnley has a Fylde smaller than 1, and a Rossendale larger than 0?
SELECT SUM("Burnley") FROM table_65584 WHERE "Fylde" < '1' AND "Rossendale" > '0'
SELECT SUM("Burnley") FROM "table_65584" WHERE "Fylde" < '1' AND "Rossendale" > '0'