SELECT
    RANK() OVER ( 
        PARTITION BY
            POINT
        ORDER BY
            POINT DESC
    ) AS RANK
    , a.USER_ID  AS USER_ID
    , SUM(b.POINT) AS POINT
    , (strftime('%s', b.SUBMITTED_AT) - strftime('%s', a.STARTED_AT)) AS EX_TIME
    , (COUNT(b.USER_ID) - 1) AS WRONG_ANS
FROM
    ENTRIES AS a
INNER JOIN SUBMISSIONS AS b ON a.ENTRY_ID = b.ENTRY_ID 
--   AND a.CONTEST_ID = b.CONTEST_ID 
--   AND a.USER_ID = b.USER_ID
WHERE
    a.CONTEST_ID  = 2 
    AND POINT > 0
    AND a.ENTRY_ID IS NOT NULL
GROUP BY a.USER_ID 
ORDER BY
    POINT DESC
    , WRONG_ANS ASC
    , a.USER_ID ASC;