with t1 as(select subject_code, rank() over(order by score) me from scores where test_code='T00001')

update scores set ranking=t1.me
from t1
where t1.subject_code=scores.subject_code
and scores.test_code='T00001';