UPDATE scores
SET passed = TRUE
WHERE score >= (select avg(score) from scores )
and subject_code = 'S00001'
or
score >= (select avg(score) from scores )
and subject_code = 'S00002'
or
score >= (select avg(score) from scores )
and subject_code = 'S00003';

UPDATE scores
SET passed = FALSE
WHERE score <= (select avg(score) from scores )
and subject_code = 'S00001'
or
score <= (select avg(score) from scores )
and subject_code = 'S00002'
or
score <= (select avg(score) from scores )
and subject_code = 'S00003';

select * from scores;