select P.playerid AS playerid,sum(P.one) AS rank,P.score AS score from
        (SELECT playerid,sum(score) AS score,1 AS one FROM tbl) P
        INNER JOIN (SELECT playerid,sum(score) AS score,1 AS one FROM tbl) Q
            ON P.score>Q.score
        GROUP BY P.playerid
        ORDER BY rank