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 é a taxa de incidentes por 100 membros para cada sindicato na região Noroeste?
 ###Tabelas: 
CREATE TABLE union_membership (member_id INT, name VARCHAR(50), union_name VARCHAR(50), region VARCHAR(50), membership_start_date DATE);CREATE TABLE workplace_safety (safety_id INT, union_name VARCHAR(50), incident_date DATE, incident_type VARCHAR(50), severity VARCHAR(50));CREATE VIEW union_membership_summary AS SELECT union_name, COUNT(*) as num_members FROM union_membership GROUP BY union_name;CREATE VIEW northwest_unions AS SELECT union_name FROM union_membership WHERE region = 'Northwest';
SELECT ums.union_name, (COUNT(*) * 100.0 / ums.num_members) as incident_rate FROM workplace_safety ws JOIN union_membership_summary ums ON ws.union_name = ums.union_name JOIN northwest_unions nu ON ws.union_name = nu.union_name GROUP BY ums.union_name;