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 s.user_id USER_ID,s.problem_id,s.point POINT ,count() filter(where wc.status <>'AC') over (partition by s.user_id) WRONG_ANS , strftime('%s',s.submitted_at) - strftime('%s',STARTED_AT) extime
    from ENTRIES e, SUBMISSIONS s,submissions wc
    where e.entry_id=s.entry_id
    and 
    s.contest_id=2
    and s.user_id=wc.user_id and s.problem_id=wc.problem_id and wc.status <> 'AC' and wc.contest_id=2
    and wc.submitted_at < s.submitted_at and s.status='AC'
    and datetime(STARTED_AT) <= datetime(STARTED_AT,'+60 minutes')
    group by 1,2)
    group by user_id order by 1,4,2