with TMP as (
    select
        row_number() over(partition by E.ENTRY_ID, S.PROBLEM_ID order by SUBMITTED_AT asc) - 1 as WA
        , E.*
        , S.SUBMITTED_AT
	    , S.POINT
	    , S.STATUS
    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(WA) + strftime('%s', max(SUBMITTED_AT)) - strftime('%s', STARTED_AT) as EX_TIME
        , sum(WA) as WRONG_ANS  
    from TMP
    where STATUS='AC'
    group by ENTRY_ID)
order by RANK asc, WRONG_ANS asc, USER_ID asc;