UPDATE
    TOTAL_SCORES
SET
    PASSED = CASE
    WHEN
        TOTAL_SCORE >= (SELECT 
                            AVG(TOTAL_SCORE) 
                        FROM
                            TOTAL_SCORES)
    THEN
        TRUE
    ELSE
        FALSE
    END
    ;