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;