UPDATE
    scores
SET
    score = FLOOR(CAST(score AS REAL) / 0.9)
WHERE 
    subject_code IN (
        SELECT subject_code
        FROM subjects
        WHERE subject_name='国語'
    );