Skip
Arish's avatar

287. Practice - UPDATE Subquery

Exercise: Update Above Average

Mark top performers.

Solution

sql
1UPDATE students SET top_performer = 1
2WHERE marks > (SELECT AVG(marks) FROM students);