with point_rank as(
select
    USER_ID
    , sum(POINT) as SUM_POINT
from
    SUBMISSIONS
where
    CONTEST_ID = 2
    and ENTRY_ID is not null
group by
    USER_ID
having
    SUM_POINT != 0
) , speed_rank as(
select
    s.USER_ID
    , strftime('%s',SUBMITTED_AT) - strftime('%s',STARTED_AT) TIME
from
    SUBMISSIONS s
    inner join ENTRIES e on s.ENTRY_ID = e.ENTRY_ID
where
    STATUS = 'AC'
group by
    s.USER_ID
)
select * from speed_rank 
;