Qual consulta exibe os nomes dos alunos que nunca foram reprovados?
A
SELECT DISTINCT A.NOME
FROM ALUNO A, HISTORICO H
WHERE A.MATRIC=H.MATRIC AND H.NOTA >= 5.0
B
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
C
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
D
SELECT A.NOME
FROM ALUNO A
WHERE A.MATRIC IN
(SELECT MATRIC FROM HISTORICO WHERE NOTA >= 5.0)
E
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