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: Encontre o valor total do investimento para empresas na indústria de 'Tecnologia'.
 ###Tabelas: 
CREATE TABLE investment (id INT PRIMARY KEY, company_id INT, investor_id INT, investment_amount INT, investment_date DATE); INSERT INTO investment (id, company_id, investor_id, investment_amount, investment_date) VALUES (1, 1, 3, 50000, '2020-01-01'); INSERT INTO investment (id, company_id, investor_id, investment_amount, investment_date) VALUES (2, 2, 4, 75000, '2019-12-15'); INSERT INTO investment (id, company_id, investor_id, investment_amount, investment_date) VALUES (3, 3, 5, 30000, '2021-02-03'); INSERT INTO company (id, name, industry, location, esg_score) VALUES (1, 'TechGiant', 'Technology', 'USA', 80); INSERT INTO company (id, name, industry, location, esg_score) VALUES (2, 'Innovatech', 'Technology', 'Canada', 70); INSERT INTO company (id, name, industry, location, esg_score) VALUES (3, 'GreenTech', 'Renewable Energy', 'Germany', 87);
SELECT SUM(i.investment_amount) AS total_investment FROM investment AS i JOIN company AS c ON i.company_id = c.id WHERE c.industry = 'Technology';