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