SCHEMA:
CREATE TABLE table_name_15 (west_lancashire INTEGER, pendle VARCHAR, rossendale VARCHAR)
USER:
What is the highest rated West Lancashire with a Pendle greater than 1 and a Rossendale more than 2?

QUERY:
SELECT MAX(west_lancashire) FROM table_name_15 WHERE pendle > 1 AND rossendale > 2