UPDATE total_scores SET ranking = (
    SELECT RANK() OVER (
        ORDER BY total_score DESC
    	)
    FROM total_scores
    );