Питання | Сторінка 612

Укажите запрос (или запросы), который выведет имена студентов-отличников (средний балл – 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 WHERE 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 = MAX(Grade))

Переглянути це питання

Crowdly