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: Quem eram as autoridades locais anteriores para a paróquia civil, Ennerdale e Kinniside, no distrito de Copeland, com menos de 1.280 habitantes?
 ###Tabelas: CREATE TABLE 2000 (2000_id AUTO_INCREMENT PRIMARY KEY, Tournament VARCHAR, Winner VARCHAR, Runner-up VARCHAR, Score VARCHAR, Third Place VARCHAR) CREATE TABLE table_of_federal_taxation_and_spending_by_state (table_of_federal_taxation_and_spending_by_state_id AUTO_INCREMENT PRIMARY KEY, Rank INT, State VARCHAR, Revenue (millions) VARCHAR, Population INT, Revenue per capita VARCHAR, Spending (millions) VARCHAR, Spending per capita VARCHAR, Net contribution per capita VARCHAR, Presidential majority 2000/2004 VARCHAR, Presidential majority 2008 VARCHAR, Presidential majority 2012 VARCHAR, Obamacare: Fed/ State/ Partnership VARCHAR) CREATE TABLE individual_hoop (individual_hoop_id AUTO_INCREMENT PRIMARY KEY, Place INT, Name VARCHAR, All Around INT, Hoop INT, Total INT) CREATE TABLE percentage_starts_from_front_row (percentage_starts_from_front_row_id AUTO_INCREMENT PRIMARY KEY, Driver VARCHAR, Front row starts INT, Pole positions INT, Entries INT, Percentage VARCHAR) CREATE TABLE list_of_civil_parishes_and_unparished_areas (list_of_civil_parishes_and_unparished_areas_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Status VARCHAR, Population INT, District VARCHAR, Former local authority VARCHAR)  
SELECT Former local authority FROM list_of_civil_parishes_and_unparished_areas WHERE Status = civil parish AND District = copeland AND Population < 1,280 AND Name = ennerdale and kinniside