select rank() over ( order by sum(point) desc ,max(extime) + (300*sum(wrong_ans)) asc) RANK ,user_id USER_ID,sum(point) POINT, max(extime) + (300*sum(wrong_ans)) EX_TIME,sum(wrong_ans) WRONG_ANS from 
    ( select distinct(s.user_id) USER_ID,s.problem_id,s.point POINT ,count() filter(where wc.status <>'AC') over (partition by s.user_id,s.problem_id) WRONG_ANS , strftime('%s',s.submitted_at) - strftime('%s',STARTED_AT) extime
            from (ENTRIES e inner join  SUBMISSIONS s on e.entry_id=s.entry_id and s.status='AC') t
            
            left join submissions wc 
            on t.user_id=wc.user_id and t.problem_id=wc.problem_id and wc.status <> 'AC' and wc.contest_id=2 and wc.submitted_at < t.submitted_at and wc.submit_id<>t.submit_id and t.status='AC'
            where 
            
            t.contest_id=2
            
            and datetime(s.submitted_at) <= datetime(STARTED_AT,'+60 minutes')
            
            ) group by user_id