update scores
set score = score + 5
from students
where scores.student_code = students.student_code;

update scores
set score = case when score > 100 then score = 100 end