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: Criar uma visualização para dados de paridade de saúde mental
 ###Tabelas: 
CREATE TABLE mental_health_parity (id INT PRIMARY KEY, state VARCHAR(20), mental_health_coverage VARCHAR(20), substance_use_coverage VARCHAR(20)); INSERT INTO mental_health_parity (id, state, mental_health_coverage, substance_use_coverage) VALUES (1, 'California', 'Yes', 'Yes'), (2, 'Texas', 'Yes', 'No'), (3, 'New York', 'Yes', 'Yes'); CREATE TABLE cultural_competency (id INT PRIMARY KEY, state VARCHAR(20), cultural_competency_training VARCHAR(20)); INSERT INTO cultural_competency (id, state, cultural_competency_training) VALUES (1, 'California', 'Yes'), (2, 'Texas', 'No'), (3, 'New York', 'Yes');
CREATE VIEW mental_health_parity_view AS SELECT m.state, m.mental_health_coverage, m.substance_use_coverage, c.cultural_competency_training FROM mental_health_parity m JOIN cultural_competency c ON m.state = c.state; WITH summary AS (SELECT state, mental_health_coverage, substance_use_coverage, cultural_competency_training, CASE WHEN mental_health_coverage = 'Yes' AND substance_use_coverage = 'Yes' AND cultural_competency_training = 'Yes' THEN 'Parity and Competency' ELSE 'No Parity or Competency' END as result FROM mental_health_parity_view) SELECT * FROM summary;