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 produtos químicos foram usados em projetos com o maior número de incidentes de segurança no último ano?
 ###Tabelas: 
CREATE TABLE chemicals (id INT PRIMARY KEY, chemical_name VARCHAR(255), supplier_id INT, FOREIGN KEY (supplier_id) REFERENCES suppliers(id)); CREATE TABLE manufacturing_projects (id INT PRIMARY KEY, name VARCHAR(255), site_id INT, start_date DATE, end_date DATE, FOREIGN KEY (site_id) REFERENCES manufacturing_sites(id)); CREATE TABLE project_chemicals (id INT PRIMARY KEY, project_id INT, chemical_name VARCHAR(255), FOREIGN KEY (project_id) REFERENCES manufacturing_projects(id), FOREIGN KEY (chemical_name) REFERENCES chemicals(chemical_name)); CREATE TABLE safety_incidents (id INT PRIMARY KEY, site_id INT, incident_type VARCHAR(255), date DATE, FOREIGN KEY (site_id) REFERENCES manufacturing_sites(id));
SELECT chemicals.chemical_name, COUNT(safety_incidents.id) AS incident_count FROM chemicals INNER JOIN project_chemicals ON chemicals.chemical_name = project_chemicals.chemical_name INNER JOIN manufacturing_projects ON project_chemicals.project_id = manufacturing_projects.id INNER JOIN safety_incidents ON manufacturing_projects.site_id = safety_incidents.site_id WHERE safety_incidents.date >= DATEADD(year, -1, GETDATE()) GROUP BY chemicals.chemical_name ORDER BY incident_count DESC;