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