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

update scores
set passed = FALSE
where passed is null;

select * from scores