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: Liste os nomes e cargos dos funcionários que não completaram o treinamento de diversidade.
 ###Tabelas: 
CREATE TABLE EmployeeTraining (EmployeeID INT, TrainingID INT, Completed BOOLEAN); CREATE TABLE Employees (EmployeeID INT, EmployeeName TEXT, JobTitle TEXT); CREATE TABLE Trainings (TrainingID INT, TrainingName TEXT); INSERT INTO Employees (EmployeeID, EmployeeName, JobTitle) VALUES (1, 'John Doe', 'Software Engineer'); INSERT INTO Employees (EmployeeID, EmployeeName, JobTitle) VALUES (2, 'Jane Smith', 'Project Manager'); INSERT INTO EmployeeTraining (EmployeeID, TrainingID, Completed) VALUES (1, 1, TRUE); INSERT INTO EmployeeTraining (EmployeeID, TrainingID, Completed) VALUES (2, 1, FALSE); INSERT INTO Trainings (TrainingID, TrainingName) VALUES (1, 'Diversity Training');
SELECT Employees.EmployeeName, Employees.JobTitle FROM Employees INNER JOIN EmployeeTraining ON Employees.EmployeeID = EmployeeTraining.EmployeeID WHERE EmployeeTraining.Completed = FALSE AND EmployeeTraining.TrainingID IN (SELECT Trainings.TrainingID FROM Trainings WHERE Trainings.TrainingName = 'Diversity Training');