Укажите запрос (или запросы), который выведет имена студентов-отличников (средний балл – 5).

SELECT StudentName FROM STUDENTS WHERE StudentId =(SELECT StudentId FROM EXAM_RESULT GROUP BY StudentId HAVING AVG(Grade) = 5)
SELECT StudentName FROM STUDENTS WHERE StudentId >= (SELECT StudentId FROM EXAM_RESULT GROUP BY StudentId HAVING AVG(Grade) = 5)
SELECT StudentName FROM STUDENTS WHERE StudentId IN (SELECT StudentId FROM EXAM_RESULT GROUP BY StudentId HAVING AVG(Grade) = 5)
SELECT StudentName FROM STUDENTS WHERE StudentId IN (SELECT StudentId FROM EXAM_RESULT WHERE Grade = 5)
SELECT StudentName FROM STUDENTS WHERE StudentId IN (SELECT StudentId FROM EXAM_RESULT WHERE Grade = MAX(Grade))

Для просмотра статистики ответов нужно войти.