SELECT
    RANK() OVER (ORDER BY POINT DESC, EX_TIME ASC) AS RANK,
    USER_ID,
    POINT,
    EX_TIME,
    EX_TIME + (300 * WRONG_ANS) AS EX_TIME,
    WRONG_ANS
FROM
(
    SELECT
        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
                WHEN S.STATUS = 'WA' AND (SELECT COUNT(*) FROM SUBMISSIONS AS SS WHERE SS.CONTEST_ID = S.CONTEST_ID AND SS.USER_ID = S.USER_ID AND SS.PROBLEM_ID = S.PROBLEM_ID AND SS.ENTRY_ID IS NOT NULL AND SS.STATUS = 'AC') = 1 THEN 1
                ELSE 0 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
        AND S.ENTRY_ID IS NOT NULL
        AND strftime('%s', S.SUBMITTED_AT) < strftime('%s', datetime(E.STARTED_AT, '+60 minutes'))
    GROUP BY E.USER_ID
    HAVING 0 = 0
        AND POINT != 0
)
ORDER BY RANK ASC, WRONG_ANS ASC, USER_ID ASC