WITH E(USER_ID, CONTEST_ID, ENTRY_ID, PROBLEM_ID, AC_AT) AS (
        SELECT
                USER_ID
                , CONTEST_ID
                , ENTRY_ID
                , PROBLEM_ID
                , MAX(SUBMITTED_AT) AS AC_AT
            FROM
                SUBMISSIONS
            WHERE
                CONTEST_ID = 2
                AND STATUS = 'AC'
                AND ENTRY_ID IS NOT NULL
            GROUP BY
                USER_ID, ENTRY_ID
        )
SELECT
    RANK() OVER (
        ORDER BY POINT DESC, EX_TIME) AS "RANK"
    , USER_ID
    , POINT
    , EX_TIME
    , WRONG_ANS
    FROM
        (
SELECT
        USER_ID
        , POINT
        , unixepoch(ENDED_AT)
                - unixepoch(STARTED_AT)
                + 300 * WRONG_ANS
            AS EX_TIME 
        , WRONG_ANS
    FROM
        ENTRIES
        INNER JOIN (
            SELECT
                    USER_ID, CONTEST_ID, ENTRY_ID
                    , MAX(AC_AT) AS ENDED_AT
                    , SUM(
                        CASE STATUS
                            WHEN 'AC' THEN 0
                            ELSE 1
                        END) AS WRONG_ANS
                    , SUM(POINT) AS POINT
                FROM
                    SUBMISSIONS
                    INNER JOIN E
                    USING (USER_ID, CONTEST_ID, ENTRY_ID, PROBLEM_ID)
                WHERE
                    SUBMITTED_AT <= AC_AT
                GROUP BY
                    USER_ID, CONTEST_ID, ENTRY_ID
        ) SS
        USING (USER_ID, CONTEST_ID, ENTRY_ID)
     ) B
    ORDER BY
        POINT DESC, EX_TIME