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.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