UPDATE
    total_scores
SET
    passed = 'TRUE'
WHERE
    total_score >= (
        SELECT
            AVG(total_score)
        FROM
            total_scores
    );
    
UPDATE
    total_scores
SET
    passed = 'FALSE'
WHERE
    total_score < (
        SELECT
            AVG(total_score)
        FROM
            total_scores
    );    

    
SELECT
    *
FROM
    total_scores;