Skip
Arish's avatar

212. Practice - Subquery 1

Exercise: Above Average

Find students with marks above class average.

Solution

sql
1SELECT name, marks FROM students
2WHERE marks > (SELECT AVG(marks) FROM students);