CREATE TABLE table_65031 ("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 is the highest rated West Lancashire with a Pendle greater than 1 and a Rossendale more than 2?
SELECT MAX("West Lancashire") FROM table_65031 WHERE "Pendle" > '1' AND "Rossendale" > '2'
SELECT MAX("West Lancashire") FROM "table_65031" WHERE "Pendle" > '1' AND "Rossendale" > '2'