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: Resumo do financiamento total e do número de projetos para cada combinação de fonte de energia e fonte de financiamento, usando uma consulta SQL com uma função de janela.
 ###Tabelas: 
CREATE TABLE green_infrastructure_funding (funding_id INT, project_id INT, funding_source VARCHAR(50), amount FLOAT, start_date DATE, end_date DATE);CREATE TABLE renewable_energy_projects (project_id INT, green_building_id INT, energy_source VARCHAR(50), capacity FLOAT, start_date DATE, end_date DATE);CREATE VIEW funded_projects AS SELECT renewable_energy_projects.project_id, renewable_energy_projects.energy_source, green_infrastructure_funding.funding_source, green_infrastructure_funding.amount FROM renewable_energy_projects JOIN green_infrastructure_funding ON renewable_energy_projects.project_id = green_infrastructure_funding.project_id;CREATE VIEW funding_summary AS SELECT funded_projects.energy_source, funded_projects.funding_source, SUM(funded_projects.amount) AS total_funding, COUNT(funded_projects.project_id) AS project_count FROM funded_projects GROUP BY funded_projects.energy_source, funded_projects.funding_source;
SELECT energy_source, funding_source, total_funding, project_count FROM funding_summary;