SCHEMA:
CREATE TABLE table_name_15 (west_lancashire INTEGER, pendle VARCHAR, rossendale VARCHAR)
User Question:
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_name_15 WHERE pendle > 1 AND rossendale > 2