WITH WS AS (
    SELECT
        USER_ID,
        SUM(POINT) AS POINT,
        MAX(strftime('%s', SUBMITTED_AT) - strftime('%s', STARTED_AT)) + SUM(CASE WHEN STATUS != 'AC' THEN 300 ELSE 0 END) AS EX_TIME,
        SUM(CASE WHEN STATUS != 'AC' THEN 1 ELSE 0 END) AS WRONG_ANS
    FROM SUBMISSIONS S
    JOIN ENTRIES USING(ENTRY_ID, CONTEST_ID, USER_ID)
    WHERE CONTEST_ID = '2' AND EXISTS(
        SELECT 1 FROM SUBMISSIONS 
        WHERE STATUS='AC' AND S.CONTEST_ID=CONTEST_ID AND S.PROBLEM_ID=PROBLEM_ID 
        AND S.USER_ID=USER_ID AND S.ENTRY_ID=ENTRY_ID AND S.SUBMITTED_AT<=SUBMITTED_AT
    )
    GROUP BY USER_ID HAVING POINT > 0
) 
SELECT
    RANK() OVER(ORDER BY POINT DESC, EX_TIME) AS RANK,
    USER_ID,
    POINT,
    EX_TIME,
    WRONG_ANS
FROM WS
ORDER BY RANK, WRONG_ANS, USER_ID