with sub as 
(
select
    PROBLEM_ID
    ,USER_ID
    ,ENTRY_ID
    ,SUBMITTED_AT
    ,STATUS
    ,POINT
    ,COUNT() over(partition by ENTRY_ID,PROBLEM_ID ORDER BY SUBMITTED_AT ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) as WRONG_ANS
from 
    SUBMISSIONS
where
    CONTEST_ID=2 and ENTRY_ID is not null
)
, sub2 as (
select
    USER_ID
    ,ENTRY_ID
    ,sum(POINT) as POINT
    ,max(SUBMITTED_AT) as END_AT
    ,sum(WRONG_ANS) as WRONG_ANS
from
    sub
where
    STATUS="AC"
group by
    ENTRY_ID
)
select
    rank() over(order by POINT desc,strftime("%s",END_AT) - strftime("%s",STARTED_AT) + WRONG_ANS*300) as `RANK`
    ,sub2.USER_ID
    ,POINT
    ,strftime("%s",END_AT) - strftime("%s",STARTED_AT) + WRONG_ANS*300 as EX_TIME
    ,WRONG_ANS
from
    sub2
    inner join
    ENTRIES as et
    on sub2.ENTRY_ID = et.ENTRY_ID
order by
    `RANK`
    ,WRONG_ANS
    ,sub2.USER_ID