Table schema:
CREATE TABLE table_name_99 (chorley INTEGER, preston VARCHAR, west_lancashire VARCHAR)

Question: What is the lowest Chorley with a 6 Preston and a 4 for West Lancashire?
SQL: SELECT MIN(chorley) FROM table_name_99 WHERE preston = 6 AND west_lancashire < 4