UPDATE total_scores
set passed = CASE WHEN total_score >= (select avg(total_score) from total_scores) THEN 'TRUE'
ELSE 'PASS'
END;