UPDATE total_scores
SET passed = 
    case
        when total_score >= sub1.avg_score
            then true
        else
            False
    end 
from (select avg(total_score) as avg_score from  total_scores) as sub1;