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

Question

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

Answer

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

Answer

SELECT StudentName FROM STUDENTS WHERE StudentId  
  IN (SELECT StudentId FROM EXAM_RESULT WHERE Grade = 5)

Answer

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

Answer

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

Answer

SELECT StudentName FROM STUDENTS WHERE StudentId  
  IN (SELECT StudentId FROM EXAM_RESULT WHERE Grade = MAX(Grade))

Crowdly