SELECT
    student_code, 
    RANK() over(order by total_score desc) as ranking
FROM
    total_scores;