UPDATE
    total_scores
SET
    passed = 
        CASE
            WHEN
                (SELECT 
                    avg(total_score)
                FROM 
                    total_scores) <= total_score
            THEN
                True
            ELSE
                False
        END;