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 número total de funcionários treinados em 'Lean Manufacturing' na região 'Europa'.
 ###Tabelas: 
CREATE TABLE manufacturers (manufacturer_id INT, manufacturer_name TEXT, region TEXT); INSERT INTO manufacturers (manufacturer_id, manufacturer_name, region) VALUES (1, 'ManufacturerA', 'North America'), (2, 'ManufacturerB', 'Europe'), (3, 'ManufacturerC', 'Asia'), (4, 'ManufacturerD', 'Asia'), (5, 'ManufacturerE', 'South America'), (6, 'ManufacturerF', 'Africa'), (7, 'ManufacturerG', 'Africa'), (8, 'ManufacturerH', 'Europe'); CREATE TABLE workforce_training (training_id INT, manufacturer_id INT, training_topic TEXT, num_employees INT); INSERT INTO workforce_training (training_id, manufacturer_id, training_topic, num_employees) VALUES (1, 3, 'Robotics', 30), (2, 3, 'Automated Guided Vehicles', 25), (3, 8, 'AI', 40), (4, 2, 'Lean Manufacturing', 50), (5, 7, 'Lean Manufacturing', 35);
SELECT m.region, SUM(wt.num_employees) as total_trained FROM manufacturers m JOIN workforce_training wt ON m.manufacturer_id = wt.manufacturer_id WHERE m.region = 'Europe' AND wt.training_topic = 'Lean Manufacturing' GROUP BY m.region;