总成绩排序并排名

SELECT
    (@y :=@y + 1) 排名,
    s_id,
    sc
FROM
    (
        SELECT
            s_id,
            SUM(s_score) AS sc
        FROM
            score
        GROUP BY
            s_id
        ORDER BY
            SUM(s_score) DESC
    ) a,
    (SELECT @y := 0) AS y;