UPDATE total_scores AS ts SET ranking = sub.ranking
FROM (SELECT student_code, RANK() 
	OVER (ORDER BY total_score DESC) AS ranking 
	FROM total_scores) AS sub
WHERE ts.student_code = sub.student_code;