CREATE TABLE table_name_97 (burnley NUMBER, fylde VARCHAR2, rossendale VARCHAR2)

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