SELECT
    RANK() OVER(ORDER BY POINT DESC, ACTUAL_TIME + 300 * WRONG_ANS ASC) AS RANK,
    USER_ID,
    POINT,
    ACTUAL_TIME + 300 * WRONG_ANS AS EX_TIME,
    WRONG_ANS
FROM (
    SELECT
        USER_ID,
        SUM(POINT) AS POINT,
        STRFTIME('%s', MAX(CASE WHEN STATUS = 'AC' THEN SUBMITTED_AT END)) - STRFTIME('%s', MAX(STARTED_AT)) AS ACTUAL_TIME,
        SUM(CASE WHEN STATUS <> 'AC' AND SUBMITTED_AT < FIRST_AC_AT THEN 1 ELSE 0 END) AS WRONG_ANS
    FROM (
        SELECT
            CONTEST_ID,
            PROBLEM_ID,
            USER_ID,
            ENTRY_ID,
            SUBMITTED_AT,
            STATUS,
            POINT,
            (
                SELECT
                    MIN(SUBMITTED_AT)
                FROM
                    SUBMISSIONS AS S2
                WHERE
                    S1.CONTEST_ID = S2.CONTEST_ID
                    AND S1.PROBLEM_ID = S2.PROBLEM_ID
                    AND S1.USER_ID = S2.USER_ID
                    AND S2.STATUS = 'AC'
                    AND ENTRY_ID IS NOT NULL
            ) AS FIRST_AC_AT
        FROM
            SUBMISSIONS AS S1
        WHERE
            CONTEST_ID = 2
            AND ENTRY_ID IS NOT NULL
    )
    INNER JOIN
        ENTRIES USING (ENTRY_ID, USER_ID, CONTEST_ID)
    GROUP BY
        USER_ID
    HAVING
        SUM(POINT) > 0
)
ORDER BY
    RANK ASC,
    WRONG_ANS ASC,
    USER_ID ASC
;