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: Calcular a mudança percentual no financiamento total para cada empresa a partir de sua rodada de investimento anterior.
 ###Tabelas: 
CREATE TABLE Investment_Rounds (id INT, company_id INT, investment_round INT, total_funding FLOAT); INSERT INTO Investment_Rounds (id, company_id, investment_round, total_funding) VALUES (1, 1, 1, 1000000), (2, 1, 2, 2500000), (3, 2, 1, 5000000), (4, 3, 1, 1000000), (5, 3, 2, 1500000), (6, 4, 1, 2000000), (7, 5, 1, 3000000), (8, 5, 2, 4000000); CREATE TABLE Companies (id INT, name TEXT, industry TEXT, total_funding FLOAT, num_investments INT); INSERT INTO Companies (id, name, industry, total_funding, num_investments) VALUES (1, 'Acme Inc', 'Software', 1000000, 2), (2, 'Beta Corp', 'Software', 5000000, 1), (3, 'Gamma Startup', 'Hardware', 1000000, 2), (4, 'Delta LLC', 'Hardware', 2000000, 1), (5, 'Epsilon Ltd', 'Consumer Products', 3000000, 2);
SELECT company_id, ((LAG(total_funding) OVER (PARTITION BY company_id ORDER BY investment_round) - total_funding) / ABS(LAG(total_funding) OVER (PARTITION BY company_id ORDER BY investment_round))) * 100 AS pct_change_funding FROM Investment_Rounds;