UPDATE scores as s
SET passed = TRUE
from (select subject_code,
    AVG(score) as avg
    from scores
    group by subject_code
    
    ) as sub
Where sub.subject_code = s.subject_code
    AND s.score >= sub.avg;
    
Update scores 
SET passed = FALSE
Where passed IS NULL;