Table: west_lancashire_derby
Columns: competition
played
blackpool
draw
preston_north_end

Question: Which Played is the lowest one that has a Blackpool smaller than 0?
SQL: SELECT MIN("played") FROM west_lancashire_derby WHERE "blackpool" < 0

Question: Which Blackpool is the highest one that has a Draw larger than 18?
SQL: SELECT MAX("blackpool") FROM west_lancashire_derby WHERE "draw" > 18

Question: How much Preston North End has a Blackpool smaller than 0?
SQL: SELECT COUNT("preston_north_end") FROM west_lancashire_derby WHERE "blackpool" < 0

Question: Which Blackpool has a Preston North End smaller than 46, and a Competition of other, and a Draw larger than 1?
SQL: SELECT SUM("blackpool") FROM west_lancashire_derby WHERE "preston_north_end" < 46 AND "competition" = 'other' AND "draw" > 1