Given a table Students with columns StudentID, Name, Age, Score, which of the…
Given a table Students with columns StudentID, Name, Age, Score, which of the following SQL queries will return the highest score for each age group?
- A.
SELECT Age, MAX(Score) FROM Students GROUP BY Age;
- B.
SELECT Age, Score FROM Students GROUP BY Age;
- C.
SELECT Age, MAX(Score) FROM Students;
- D.
SELECT Age, Score FROM Students WHERE Score = (SELECT MAX(Score) FROM Students GROUP BY Age);
Attempted by 625 students.
Sign up free to check your answer
Sign up freeLoading lesson…