WITH TEMP AS
(
    SELECT
         MAIN.USER_ID   AS USER_ID
        ,SUM(SUB.POINT) AS POINT
        ,strftime('%s', MAX(SUB.SUBMITTED_AT)) - strftime('%s', STARTED_AT) AS EX_TIME
        ,SUM(CASE WHEN STATUS != 'AC' THEN 1 ELSE 0 END) AS WRONG_ANS
    FROM ENTRIES AS MAIN
         INNER JOIN SUBMISSIONS AS SUB
         ON MAIN.ENTRY_ID = SUB.ENTRY_ID
    WHERE MAIN.CONTEST_ID  = 2
    GROUP BY MAIN.USER_ID
)
SELECT
     RANK() OVER(ORDER BY POINT DESC, EX_TIME DESC, WRONG_ANS) AS RANK
    ,USER_ID
    ,POINT
    ,EX_TIME
    ,WRONG_ANS
FROM TEMP
ORDER BY RANK, WRONG_ANS, USER_ID