UPDATE total_scores
SET
    passed = CASE
                WHEN
                    total_score >= (SELECT AVG(total_score) FROM total_scores) THEN TRUE
                ELSE
                    FALSE
                END;