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 ;