Which of the following command can display the SEC-wise average of the students?

2023

Answer: C. SELECT SEC, AVG(MARKS) FROM MYSTUDENT GROUP BY SEC; — Key idea: group rows by SEC so AVG(MARKS) is computed for each section. Use this SQL command: SELECT SEC, AVG(MARKS) FROM MYSTUDENT GROUP BY SEC; GROUP BY SEC…

1. A.

   SELECT SEC, AVG(MARKS) FROM MYSTUDENT ORDER BY SEC;

2. B.

   SELECT SEC, AVG(MARKS) FROM MYSTUDENT GROUP BY MARKS;

3. C.

   SELECT SEC, AVG(MARKS) FROM MYSTUDENT GROUP BY SEC;

4. D.

   SELECT AVG(MARKS) FROM MYSTUDENT ORDER BY SEC;

Attempted by 1802 students.

A video solution is available for this question — log in and enroll to watch it.