with TMP as (
    select
        row_number() over(partition by E.USER_ID, S.PROBLEM_ID order by SUBMITTED_AT) - 1 as PEN
        , S.*
        , E.STARTED_AT
    from ENTRIES as E
    inner join SUBMISSIONS as S
        on E.ENTRY_ID=S.ENTRY_ID
    where E.CONTEST_ID=2
)
select
    rank() over(order by POINT desc, EX_TIME asc) as RANK
    , *
from (select
        USER_ID
        , sum(POINT) as POINT
        , 300*sum(PEN) + strftime('%s', max(SUBMITTED_AT)) - strftime('%s', STARTED_AT) as EX_TIME
        , sum(PEN) as WRONG_ANS  
    from TMP
    where STATUS='AC'
    group by USER_ID)
where POINT>0
order by RANK , WRONG_ANS, USER_ID;