select
    rank() over(
        order by
            POINT desc
    ) as RANK,
    USER_ID,
    POINT,
    strftime('%s', MAX_SUBMITTED_AT) - strftime('%s', STARTED_AT) + 300*ifnull(PROBLEM_COUNT.PROBLEM_COUNT, 0) as EX_TIME,
    ifnull(PROBLEM_COUNT.PROBLEM_COUNT, 0) AS WRONG_ANS
from
    ENTRIES
    inner join(
        select
            ENTRY_ID,
            max(SUBMITTED_AT) as MAX_SUBMITTED_AT
        from
            SUBMISSIONS
        where
            STATUS = "AC"
        group by
            ENTRY_ID
    ) as MAX_SUBMITTED_AT on ENTRIES.ENTRY_ID = MAX_SUBMITTED_AT.ENTRY_ID
    inner join(
        select
            ENTRY_ID,
            sum(POINT) as POINT
        from
            SUBMISSIONS
        group by
            ENTRY_ID
    ) as POINT on ENTRIES.ENTRY_ID = POINT.ENTRY_ID
    left join(
        select
            ENTRY_ID,
            count(PROBLEM_COUNT) AS PROBLEM_COUNT
        from
            (
                select
                    SUBMISSIONS.ENTRY_ID,
                    SUBMISSIONS.PROBLEM_ID,
                    count(SUBMISSIONS.PROBLEM_ID) as PROBLEM_COUNT
                from
                    SUBMISSIONS
                    left join(
                        select
                            ENTRY_ID,
                            PROBLEM_ID,
                            max(SUBMITTED_AT) as AC_SUBMITTED_AT
                        from
                            SUBMISSIONS
                        where
                            STATUS = "AC"
                        group by
                            ENTRY_ID,
                            PROBLEM_ID
                    ) as AC_SUBMITTED_AT on SUBMISSIONS.ENTRY_ID = AC_SUBMITTED_AT.ENTRY_ID
                    and SUBMISSIONS.PROBLEM_ID = AC_SUBMITTED_AT.PROBLEM_ID
                where
                    STATUS = "WA"
                    and SUBMITTED_AT < AC_SUBMITTED_AT
                group by
                    SUBMISSIONS.ENTRY_ID,
                    SUBMISSIONS.PROBLEM_ID
            )
        group by
            ENTRY_ID
    ) as PROBLEM_COUNT on ENTRIES.ENTRY_ID = PROBLEM_COUNT.ENTRY_ID
where
    CONTEST_ID = 2
    and POINT <> 0
order by
    RANK,
    POINT,
    USER_ID