UPDATE total_scores AS ts
SET passed = CASE WHEN ts.total_score < AVERAGE THEN TRUE
ELSE FALSE END
FROM (SELECT student_code, total_score,
AVG(total_score) OVER() AS AVERAGE
FROM total_scores) AS SUB
WHERE ts.student_code = SUB.student_code