SELECT
    RANK() OVER (ORDER BY POINT DESC) AS RANK,
    s.USER_ID,
    SUM(s.POINT) AS POINT,
    MAX(CASE WHEN s.STATUS = 'AC' THEN strftime('%s', s.SUBMITTED_AT) ELSE 0 END) - strftime('%s', e.STARTED_AT) + 300 * SUM(CASE WHEN s.STATUS = 'WA' THEN 1 ELSE 0 END) AS EX_TIME,
    SUM(CASE WHEN s.STATUS = 'WA' THEN 1 ELSE 0 END) AS WRONG_ANS
FROM
    ENTRIES AS e
    INNER JOIN
        SUBMISSIONS AS s
    ON
        e.USER_ID = s.USER_ID
WHERE 0=0
    AND e.CONTEST_ID = 2
    AND e.ENTRY_ID IS NOT NULL
GROUP BY
    e.USER_ID
HAVING 0=0
    AND POINT != 0
    AND MAX(CASE WHEN s.STATUS = 'AC' THEN strftime('%s', s.SUBMITTED_AT) ELSE 0 END) - strftime('%s', e.STARTED_AT) <= 3600
ORDER BY
    RANK,
    WRONG_ANS,
    e.USER_ID