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: Quantas organizações cada investidor apoia e qual é o montante total de investimento no setor de energia renovável?
 ###Tabelas: 
CREATE TABLE investments (investment_id INT, investor_id INT, org_id INT, investment_amount INT); INSERT INTO investments (investment_id, investor_id, org_id, investment_amount) VALUES (1, 1, 6, 55000), (2, 2, 7, 65000), (3, 1, 5, 90000), (4, 3, 6, 70000), (5, 2, 5, 85000); CREATE TABLE investors (investor_id INT, investor_name TEXT); INSERT INTO investors (investor_id, investor_name) VALUES (1, 'Investor G'), (2, 'Investor H'), (3, 'Investor I'); CREATE TABLE organizations (org_id INT, org_name TEXT, focus_topic TEXT); INSERT INTO organizations (org_id, org_name, focus_topic) VALUES (5, 'Org 5', 'Renewable Energy'), (6, 'Org 6', 'Renewable Energy'), (7, 'Org 7', 'Healthcare');
SELECT investors.investor_name, COUNT(organizations.org_id) AS orgs_supported, SUM(investments.investment_amount) AS total_invested FROM investments JOIN investors ON investments.investor_id = investors.investor_id JOIN organizations ON investments.org_id = organizations.org_id WHERE organizations.focus_topic = 'Renewable Energy' GROUP BY investors.investor_name;