with TMP as (
    select
        row_number() over(partition by E.USER_ID, S.PROBLEM_ID order by SUBMITTED_AT asc) - 1  as PEN
        , S.POINT
        , S.SUBMITTED_AT
        , S.STATUS
        , E.USER_ID
        , E.STARTED_AT
    from ENTRIES as E
    inner join SUBMISSIONS as S
        on E.ENTRY_ID=S.ENTRY_ID and S.ENTRY_ID is not null
    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', min(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;