Table: lancashire_2009_election
Columns: party
burnley
chorley
fylde
hyndburn
lancaster
pendle
preston
ribble_valley
rossendale
south_ribble
west_lancashire
wyre
total

Question: Which Pendle has a Burnley smaller than 0?
SQL: SELECT SUM("pendle") FROM lancashire_2009_election WHERE "burnley" < 0

Question: How much Rossendale has a Fylde smaller than 0?
SQL: SELECT COUNT("rossendale") FROM lancashire_2009_election WHERE "fylde" < 0

Question: How much Hyndburn has a Fylde larger than 3?
SQL: SELECT SUM("hyndburn") FROM lancashire_2009_election WHERE "fylde" > 3

Question: How much Burnley has a Fylde smaller than 1, and a Rossendale larger than 0?
SQL: SELECT SUM("burnley") FROM lancashire_2009_election WHERE "fylde" < 1 AND "rossendale" > 0