SELECT
    RANK() OVER(ORDER BY SUM(S.POINT) DESC) AS RANK,
    S.USER_ID AS USER_ID,
    SUM(S.POINT) AS POINT,
    MAX(SUBMITTED_AT - E.STARTED_AT) AS EX_TIME
--    '誤答数' AS WRONG_ANS
FROM
    SUBMISSIONS AS S
INNER JOIN
    ENTRIES AS E
ON
    S.ENTRY_ID = E.ENTRY_ID
GROUP BY
    S.USER_ID;