UPDATE SCORES
SET SCORE = SCORE + 5
FROM STUDENTS AS ST
WHERE ST.STUDENT_CODE = SCORES.STUDENT_CODE
AND ST.STUDENT_NAME IN("佐藤 幸平","山田 康介");

UPDATE SCORES
SET SCORE = (CASE WHEN SCORE > 100 THEN 100 ELSE SCORE END);