Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Укажите запрос (или запросы), который выведет имена студентов-отличников (средний балл – 5).
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))
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!