with avg_scores as (
    select avg(total_score) as avg_score from total_scores
)

update
    total_scores
set
    passed = 
        case
            WHEN (select avg_score from avg_scores) <= total_score THEN TRUE
            ELSE FALSE
        END;