update scores
set passed = TRUE
from
(
select subject_code, avg(score) as score_avg
from scores
group by subject_code
) as A
where scores.subject_code = A.subject_code and scores.score >= A.score_avg;

update scores
set passed = FALSE
where passed is NULL;
    
select * from scores