CREATE TABLE table_65032 ("Party" TEXT, "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)

What was the average Chorley for the Labour party that had a Rossendale greater than 0 and a Pendle less than 1?
SELECT AVG("Chorley") FROM table_65032 WHERE "Rossendale" > '0' AND "Party" = 'labour' AND "Pendle" < '1'
SELECT AVG("Chorley") FROM "table_65032" WHERE "Party" = 'labour' AND "Pendle" < '1' AND "Rossendale" > '0'