Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quanto Burnley tem um Fylde menor que 1 e um Rossendale maior que 0?
 ###Tabelas: CREATE TABLE by_clubs (by_clubs_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Matches INT, Wins INT, Wins % VARCHAR, Draws INT, Draws % VARCHAR, Losses INT, Losses % VARCHAR, Against INT, For & Against Ratio VARCHAR) CREATE TABLE 1957 (1957_id AUTO_INCREMENT PRIMARY KEY, Title VARCHAR, Series VARCHAR, Director VARCHAR, Release date VARCHAR, reissue? VARCHAR) CREATE TABLE grounds (grounds_id AUTO_INCREMENT PRIMARY KEY, Name of ground VARCHAR, Location VARCHAR, First-class span VARCHAR, Worcs f-c matches INT, List A span VARCHAR, Worcs LA matches INT) CREATE TABLE summary_of_results (summary_of_results_id AUTO_INCREMENT PRIMARY KEY, Party VARCHAR, Burnley INT, Chorley INT, Fylde INT, Hyndburn INT, Lancaster INT, Pendle INT, Preston INT, Ribble Valley INT, Rossendale INT, South Ribble INT, West Lancashire INT, Wyre INT, Total INT) CREATE TABLE record_vs._other_opponents_at_least_15_games_played (record_vs._other_opponents_at_least_15_games_played_id AUTO_INCREMENT PRIMARY KEY, Missouri vs. VARCHAR, Overall Record VARCHAR, at Columbia VARCHAR, at Opponents Venue VARCHAR, at Neutral Site VARCHAR, Last 5 Meetings VARCHAR, Last 10 Meetings VARCHAR, Current Streak VARCHAR)  
SELECT SUM Burnley FROM summary_of_results WHERE Fylde < 1 AND Rossendale > 0