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
    *
from (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
        ))
where POINT > 0
order by RANK asc, WRONG_ANS asc, USER_ID asc