update scores
set score = score + 5
from students
where scores.student_code = students.student_code
and scores.student_code in ('A00016', 'A00095');

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