WITH avg_score_table as (
    SELECT 
        AVG(total_score) AS avg_score
    FROM 
        total_scores
)
UPDATE
    total_scores as ts
SET
    passed = CASE
            WHEN ast.avg_score <= ts.total_score THEN TRUE
            ELSE FALSE
            END
FROM
    avg_score_table as ast;