221. Correlated in SELECT

1SELECT name, marks,
2  (SELECT AVG(marks) FROM students
3   WHERE course = s.course) AS course_avg
4FROM students s;