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