UPDATE scores
SET passed = CASE
WHEN score >= A.avg THEN 'TRUE'
ELSE 'FALSE' END
FROM(
SELECT student_code,avg(score)AS avg
FROM scores
GROUP BY student_code
)AS A
WHERE scores.student_code = A.student_code