Qual consulta exibe os nomes dos alunos que nunca foram r...

SELECT DISTINCT A.NOME

FROM ALUNO A, HISTORICO H

WHERE A.MATRIC=H.MATRIC AND H.NOTA >= 5.0

SELECT NOME FROM ALUNO M

INUS

SELECT DISTINCT A.NOME

FROM ALUNO A, HISTORICO H

WHERE A.MATRIC=H.MATRIC

GROUP BY A.NOME, H.NOTA

HAVING H.NOTA < 5.0

SELECT DISTINCT A.NOME

FROM ALUNO A, HISTORICO H

WHERE A.MATRIC=H.MATRIC

GROUP BY A.NOME, H.NOTA

HAVING H.NOTA >=5.0

SELECT A.NOME

FROM ALUNO A

WHERE A.MATRIC IN

(SELECT MATRIC FROM HISTORICO WHERE NOTA >= 5.0)

SELECT DISTINCT A.NOME

FROM ALUNO A

LEFT OUTER JOIN HISTORICO H

ON A.MATRIC=H.MATRIC

GROUP BY A.NOME, H.NOTA

HAVING H.NOTA >=5.0