with tmp1 as(
select USER_ID,CONTEST_ID,POINT,ENTRY_ID,
datetime(SUBMITTED_AT) as SUBMITTED_AT,
max(case status when 'AC' then datetime(SUBMITTED_AT) end)
over(partition by USER_ID,ENTRY_ID,PROBLEM_ID) as ACTime
  from SUBMISSIONS
 where ENTRY_ID is not null
   and CONTEST_ID = 2),
tmp2 as (
select USER_ID,
max(ACTime) as maxACTime,
sum(case when SUBMITTED_AT < ACTime
         then 1 else 0 end) as WRONG_ANS,
sum(POINT) as SumPoint,
(select b.STARTED_AT
   from ENTRIES b
  where b.CONTEST_ID = a.CONTEST_ID
    and b.ENTRY_ID = a.ENTRY_ID
    and b.USER_ID = a.USER_ID) as STARTED_AT
  from tmp1 a
 where ACTime is not null
 group by USER_ID,ENTRY_ID
 having sum(POINT) > 0),
tmp3 as(
select *,
strftime('%s',maxACTime) - strftime('%s',STARTED_AT) + WRONG_ANS * 300 as EX_TIME
 from tmp2
where STARTED_AT is not null)
select rank() over(order by SumPoint desc, EX_TIME) as RANK,
USER_ID,SumPoint as POINT,EX_TIME,WRONG_ANS
  from tmp3
order by RANK,WRONG_ANS,USER_ID