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: Qual é o número total de incidentes de emergência relatados por cada bairro no distrito 3?
 ###Tabelas: 
CREATE TABLE districts (id INT, name VARCHAR(255)); INSERT INTO districts (id, name) VALUES (3, 'Downtown'); CREATE TABLE neighborhoods (id INT, district_id INT, name VARCHAR(255)); INSERT INTO neighborhoods (id, district_id, name) VALUES (101, 3, 'Central Park'); INSERT INTO neighborhoods (id, district_id, name) VALUES (102, 3, 'Riverview'); CREATE TABLE emergency_incidents (id INT, neighborhood_id INT, reported_date DATE); INSERT INTO emergency_incidents (id, neighborhood_id, reported_date) VALUES (1001, 101, '2021-01-01'); INSERT INTO emergency_incidents (id, neighborhood_id, reported_date) VALUES (1002, 101, '2021-01-02'); INSERT INTO emergency_incidents (id, neighborhood_id, reported_date) VALUES (1003, 102, '2021-01-01');
SELECT neighborhoods.name, COUNT(emergency_incidents.id) AS total_incidents FROM neighborhoods JOIN emergency_incidents ON neighborhoods.id = emergency_incidents.neighborhood_id WHERE neighborhoods.district_id = 3 GROUP BY neighborhoods.name;