select RANK() over(order by b.POINT desc, b.EX_TIME) RANK
, b.USER_ID
, b.POINT
, b.EX_TIME
, b.WRONG_ANS
from (
select s1.USER_ID
, sum(S1.POINT) POINT 
, sum(case when s1.STATUS != 'AC' then 1 else 0 end) WRONG_ANS
 , cast((julianday(a.MAX_SUBMITTED_AT)
        - julianday(e.STARTED_AT))* 24 * 60 * 60 as integer) 
  + (sum(case when s1.STATUS != 'AC' then 1 else 0 end) * 300)
 as EX_TIME
 , e.STARTED_AT
 , a.MAX_SUBMITTED_AT
from (
select  s0.USER_ID
, s0.ENTRY_ID, s0.CONTEST_ID
, max(s0.SUBMITTED_AT) MAX_SUBMITTED_AT
from SUBMISSIONS s0
where s0.CONTEST_ID = 2
and s0.STATUS = 'AC'
and s0.ENTRY_ID is not null
group by s0.USER_ID
, s0.ENTRY_ID, s0.CONTEST_ID
) a
inner join ENTRIES e
  on e.ENTRY_ID = a.ENTRY_ID
  and e.CONTEST_ID = a.CONTEST_ID
  and e.USER_ID = a.USER_ID
inner join SUBMISSIONS s1
  on s1.USER_ID = a.USER_ID
  and s1.ENTRY_ID = a.ENTRY_ID
  and s1.CONTEST_ID = a.CONTEST_ID
  and s1.SUBMITTED_AT <= a.MAX_SUBMITTED_AT
  

group by s1.USER_ID
having sum(S1.POINT) > 0
) b
order by RANK
, WRONG_ANS
, USER_ID
;