UPDATE 
    scores
SET
    score = score * 10/9
INNER JOIN
    subjects as sb
ON
    subject_code = sb.subject_code
WHERE
    sb.subject_name = "国語";

select * from scores;