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*wrong_ans) EX_TIME,sum(wrong_ans) over(partition by user_id) WRONG_ANS from 
        (
        select s.user_id USER_ID,s.problem_id,s.point POINT ,count(wc.submit_id) AS WRONG_ANS , strftime('%s',s.submitted_at) - strftime('%s',STARTED_AT) extime
        from ENTRIES e, SUBMISSIONS s left join submissions wc on 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
        where e.entry_id=s.entry_id
        and 
        s.contest_id=2
        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