select
 RANK() over( order by a.POINT desc, a.WRONG_ANS, a.USER_ID ) RANK
, a.*
from (
select
e.USER_ID
, sum(s.POINT) POINT
, cast((julianday(max(case when s.STATUS = 'AC' then s.SUBMITTED_AT else 0 end))
        - julianday(min(s.SUBMITTED_AT)))* 24 * 60 * 60 as integer) 
  + (sum(case when s.STATUS != 'AC' then 1 else 0 end) * 300)
 as EX_TIME
, s.STATUS
, sum(case when s.STATUS != 'AC' then 1 else 0 end) WRONG_ANS
from ENTRIES e
     inner join SUBMISSIONS s
       on s.ENTRY_ID = e.ENTRY_ID
       and s.CONTEST_ID = e.CONTEST_ID
       and s.USER_ID = e.USER_ID
where e.CONTEST_ID = 2
group by e.USER_ID
having sum(s.POINT) > 0
) a
order by POINT desc

;