CREATE TABLE table_name_99 (chorley INT, preston VARCHAR, west_lancashire VARCHAR)

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