UPDATE scores
SET score = FLOOR(score / 0.9)
WHERE scores.subject_code = (
    SELECT sub.subject_code
    FROM subjects sub
    WHERE sub.subject_name = '国語'
);