update total_scores
set
    passed = TRUE
where
    total_score >= (select avg(total_score) from total_scores group by student_code);
update total_scores
set
    passed = FALSE
where
    total_score < (select avg(total_score) from total_scores group by student_code);    

select
    *
from
    total_scores