with TMP as (
    select
        S.USER_ID
        , S.PROBLEM_ID
        , S.STATUS
        , S.POINT
        , strftime('%s', S.SUBMITTED_AT) - strftime('%s', E.STARTED_AT) AS DIFF
        , count(*) over(partition by S.USER_ID, S.PROBLEM_ID
                        order by S.SUBMITTED_AT asc
                        rows between unbounded preceding and 1 preceding) as WA_CNT
    from SUBMISSIONS as S
    join ENTRIES as E on S.ENTRY_ID = E.ENTRY_ID
    where S.CONTEST_ID = 2 AND S.ENTRY_ID is not null
)
select
    rank() over(order by POINT desc, EX_TIME asc) as RANK
    , *
from (select
        USER_ID
        , sum(POINT) AS POINT
        , max(DIFF) + 300*sum(WA_CNT) AS EX_TIME
        , sum(WA_CNT) AS WRONG_ANS
    from TMP
    where STATUS = 'AC'
    group by USER_ID
    )
order by POINT desc, EX_TIME asc, WRONG_ANS asc, USER_ID asc;