UPDATE total_scores
SET passed = 
    CASE WHEN total_score >= ts2.avg THEN TRUE
    ELSE FALSE END
FROM (
    SELECT AVG(total_score) AS avg
    FROM total_scores
)AS ts2