UPDATE scores AS T1
SET  score = CASE WHEN score >=100 THEN score ELSE 100 END 
FROM  students AS T2
WHERE T1.student_code = T2.student_code -- WHERE句に結合条件を指定
    AND T2.student_name = '佐藤 幸平' OR '山田 康介';
SELECT *
FROM
    scores