Consider the following Students table | student_id | name | grade | marks | |---|---|---|---| | 1001 | Alice | A | 85 | | 1002 | Bob | B | 70 | | 1003 | Charlie | A | 90 | | 1004 | David | B | 60 | | 1005 | Eve | A | 95 | Figure 1: Students Choose the correct SQL query to calculate the average marks scored by students in each grade and sort the result by average marks in descending order.

(B) Option figure from the original question paper

(C) Option figure from the original question paper

(A) Option figure from the original question paper

(D) Option figure from the original question paper

Database Management Systems · Quiz 1 · 23 Feb 2025 · January 2025 term

Question 10: Consider the following Students table | student_id | nam…

Question 10

+4 marksOne or more correct options

Consider the following Students table

student_id	name	grade	marks
1001	Alice	A	85
1002	Bob	B	70
1003	Charlie	A	90
1004	David	B	60
1005	Eve	A	95

Figure 1: Students

Choose the correct SQL query to calculate the average marks scored by students in each grade and sort the result by average marks in descending order.

Select all that apply.

Show answer

Correct answers

See the whole paper Take it as a mock test

Question 10 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 23 Feb 2025, in the January 2025 term (IIT M DIPLOMA AN EXAM QDD2 23 Feb 2025). It carries 4 marks.

Question 10: Consider the following Students table | student_id | nam…

Question 10

More questions from this paper