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