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