Questão 40 – Tecnologia da Informação – CEBRASPE 2021 – Tribunal de Justiça do Estado do Rio de Janeiro (Analista Judiciário)

SELECT J.nome FROM Juiz AS J WHERE J.nome NOT IN (SELECT P.codjuiz FROM Processo AS P);

SELECT J.nome FROM Juiz AS J, Processo AS P WHERE J.codjuiz inner join P.codjuiz;

SELECT J.nome FROM Juiz AS J WHERE J.codjuiz NOT IN (SELECT P.codjuiz FROM Processo AS P);

SELECT J.nome FROM Juiz AS J WHERE J.codjuiz LIKE (SELECT P.codjuiz FROM Processo AS P);

SELECT J.nome FROM Juiz AS J, Processo AS P WHERE J.nome NOT EXISTS (P.codjuiz);