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: Quais fornecedores sustentáveis fabricaram produtos que foram vendidos nos Estados Unidos?
 ###Tabelas: 
CREATE TABLE suppliers (id INT PRIMARY KEY, name VARCHAR(50), country VARCHAR(50), sustainable_materials BOOLEAN); CREATE TABLE manufacturers (id INT PRIMARY KEY, name VARCHAR(50), country VARCHAR(50), supplier_id INT, FOREIGN KEY (supplier_id) REFERENCES suppliers(id)); CREATE TABLE products (id INT PRIMARY KEY, name VARCHAR(50), price DECIMAL(5,2), manufacturer_id INT, FOREIGN KEY (manufacturer_id) REFERENCES manufacturers(id)); CREATE TABLE sales (id INT PRIMARY KEY, product_id INT, quantity INT, FOREIGN KEY (product_id) REFERENCES products(id)); CREATE VIEW sales_summary AS SELECT products.name, SUM(sales.quantity) as total_sold FROM sales JOIN products ON sales.product_id = products.id GROUP BY products.name;
SELECT DISTINCT suppliers.name AS supplier_name FROM suppliers INNER JOIN manufacturers ON suppliers.id = manufacturers.supplier_id INNER JOIN products ON manufacturers.id = products.manufacturer_id INNER JOIN sales ON products.id = sales.product_id INNER JOIN sales_summary ON products.name = sales_summary.name INNER JOIN manufacturers m2 ON suppliers.id = m2.supplier_id WHERE suppliers.sustainable_materials = TRUE AND m2.country = 'United States';