How much Burnley has a Fylde smaller than 1, and a Rossendale larger than 0?
CREATE TABLE table_name_97 (
    burnley INTEGER,
    fylde VARCHAR,
    rossendale VARCHAR
)
SELECT SUM(burnley) FROM table_name_97 WHERE fylde < 1 AND rossendale > 0
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How much Burnley has a Fylde smaller than 1, and a Rossendale larger than 0? ### Input: CREATE TABLE table_name_97 (
    burnley INTEGER,
    fylde VARCHAR,
    rossendale VARCHAR
) ### Response: SELECT SUM(burnley) FROM table_name_97 WHERE fylde < 1 AND rossendale > 0