Выведите номера зачеток (идентификаторы студентов) и средние баллы, которые получили студенты за все экзамены. Какие варианты запросов верны?

Question

Accepted Answer

SELECT StudentId, AVG(Grade) FROM Exam_Result GROUP BY StudentId

Answer

SELECT StudentId, AVG(Grade) FROM Students

Answer

SELECT StudentId, AVG(Grade) FROM Students GROUP BY StudentId

Answer

SELECT StudentId, AVG(Grade) FROM Exam_Result

Answer

SELECT  AVG(Grade) FROM Exam_Result GROUP BY StudentId

Answer

SELECT  StudentId,  AVG(DISTINCT Grade) FROM Exam_Result GROUP BY StudentId

Crowdly