WITH average_score AS (
    SELECT
        avg(total_score) AS avg_score
    FROM
        total_scores
)

UPDATE
    total_scores
SET
    passed = 
        CASE
            WHEN total_score >= avg_score THEN True
        ELSE
            False
        END
FROM
    average_score;