UPDATE scores as s
SET passed = TRUE
FROM (
SELECT subject_code,
AVG(score) AS avg
FROM scores 
GROUP BY subject_code) AS sub

WHERE s.subject_code = sub.subject_code
AND s.score >= sub.avg;

UPDATE scores
SET passed = FALSE
WHERE passed IS NULL;

SELECT *
FROM total_scores;