Oracle如何分组排序并产生序号

SELECT
    C.ORG_SHORTNAME,
    B.USER_NAME,
    ROW_NUMBER () OVER ( PARTITION BY B.ORG_ID ORDER BY A.TOTAL_SCORE DESC ) CNO,
    A.TOTAL_SCORE,
    A.USER_ID
FROM
    T_INDIVIDUAL_RANKING A
    INNER JOIN T_USER B ON A.USER_ID = B.USER_ID
    INNER JOIN SYS_ORG C ON C.ORG_ID = B.ORG_ID