UPDATE
    SCORES AS SC
SET
    RANKING = SC_2.RK
FROM
    (SELECT
        SCORE
        ,RANK()OVER(PARTITION BY SUBJECT_CODE ORDER BY SCORE DESC) AS RK
    FROM
        SCORES
     ) SC_2
WHERE
    SC.SCORE = SC_2.SCORE
;