UPDATE 
    total_scores
SET 
    passed = case when(total_score >= sub.avg)then true
    else
        false
    end
from
    (SELECT 
        AVG(total_score) as avg
     from 
        total_scores
    )as sub;