--select * from scores
--where student_code = 'A00016' or student_code = 'A00095';

UPDATE scores
SET score = case when score>=95 then 100 else score+5 end
FROM students
WHERE scores.student_code = students.student_code -- WHERE句に結合条件を指定
AND (students.student_name = '佐藤 幸平'
or  students.student_name = '山田 康介');