Select the correct SQL query that returns all students whose results are greater than the

Question

Select the correct SQL query that returns all students whose results are greater than the
average result of their respective departments.

Accepted Answer

SELECT stu_id
             FROM student s
             WHERE result > (SELECT AVG(result) FROM student WHERE dept_id = s.dept_id);

Answer

SELECT stu_id
            FROM student
            WHERE result > (SELECT AVG(result) FROM student GROUP BY dept_id);

Answer

SELECT stu_id
            FROM student
            WHERE result > AVG(result) GROUP BY dept_id;

Answer

SELECT stu_id
            FROM student s
            WHERE result > (SELECT AVG(s.result) FROM student);

From DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 3 (5:00 PM)