with st as (select 
user_id, entry_id, started_at from entries where contest_id = 2
)
, ss as (select
submissions.*, st.started_at from submissions join st on submissions.entry_id = st.entry_id and submissions.entry_id is not null
)
, points as (
select user_id, sum(point) as sump from ss
group by USER_ID
)
, ex as (
select *, strftime('%s', submitted_at) - strftime('%s', started_at) as diff
from ss
where status = 'AC'
group by user_id, problem_id
)
, ex2 as (
select USER_ID, max(diff) as sumdiff from ex group by USER_ID
)
, wa as (
select *
from ss
where status = 'WA' and exists
(select 1 from ex where ss.user_id = ex.user_id and ss.problem_id = ex.problem_id and ss.submitted_at < ex.submitted_at)
)
, wa2 as (select user_id, count(1) as cnt from wa group by user_id)
, fin as (select points.user_id as USER_ID, points.sump as POINT, ex2.sumdiff + ifnull(wa2.cnt, 0) * 300 as EX_TIME, ifnull(wa2.cnt, 0) as WRONG_ARGS from points join ex2 on points.user_id = ex2.user_id left join wa2 on points.user_id = wa2.user_id)
, fin2 as (select *, rank() over (order by POINT desc, EX_TIME) as RANK from fin)
select RANK, USER_ID, POINT, EX_TIME, WRONG_ARGS as WRONG_ANS from fin2
wheRE POINT != 0
order by RANK, WRONG_ARGS, USER_ID
-- select * from wa2
-- select * from ex2