SELECT
    RANK() OVER (ORDER BY POINT DESC, TIME + WRONG_ANS * 300 ASC) AS RANK,
    USER_ID,
    POINT,
    TIME + WRONG_ANS * 300 AS EX_TIME,
    WRONG_ANS
FROM (
    SELECT
        ENTRIES.USER_ID,
        SUM(SUBMISSIONS.POINT) AS POINT,
        ROUND((JULIANDAY(MAX(SUBMISSIONS.SUBMITTED_AT)) - JULIANDAY(ENTRIES.STARTED_AT)) * 86400) AS TIME,
        SUM(CASE SUBMISSIONS.STATUS WHEN 'AC' THEN 0 ELSE 1 END) AS WRONG_ANS
    FROM
        SUBMISSIONS
    INNER JOIN
        ENTRIES ON
        ENTRIES.CONTEST_ID = SUBMISSIONS.CONTEST_ID AND
        ENTRIES.ENTRY_ID = SUBMISSIONS.ENTRY_ID
    INNER JOIN (
        SELECT
            CONTEST_ID,
            PROBLEM_ID,
            ENTRY_ID,
            SUBMITTED_AT,
            POINT
        FROM
            SUBMISSIONS
        WHERE
            ENTRY_ID IS NOT NULL AND
            STATUS = 'AC'
    ) AS
        LAST_SUBMISSIONS ON
        LAST_SUBMISSIONS.CONTEST_ID = SUBMISSIONS.CONTEST_ID AND
        LAST_SUBMISSIONS.PROBLEM_ID = SUBMISSIONS.PROBLEM_ID AND
        LAST_SUBMISSIONS.ENTRY_ID = SUBMISSIONS.ENTRY_ID AND
        LAST_SUBMISSIONS.SUBMITTED_AT >= SUBMISSIONS.SUBMITTED_AT
    GROUP BY
        ENTRIES.USER_ID,
        ENTRIES.STARTED_AT
) AS SUBMISSIONS
ORDER BY
    RANK ASC,
    WRONG_ANS ASC,
    USER_ID ASC