update scores
set score = score + 5
from students
where scores.student_code = students.student_code
and (students.student_name = '佐藤 幸平' or students.student_name = '山田 康介');

UPDATE scores
SET score = CASE WHEN score >= 100 THEN 100
ELSE score
END ;

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