SELECT
    RANK() OVER(ORDER BY POINT DESC,EX_TIME DESC) AS RANK
    ,USER_ID
    ,POINT
    ,WAEX_TIME
    ,WRONG_ANS
FROM
    (
            
        SELECT
            
            ,E.USER_ID
            ,SUM(S.POINT)
            ,COUNT(CASE WHEN S.STATUS <> 'AC' AND S.SUBMITTED_AT < AC.SUBMITTED_AT THEN 1 ELSE 0 END ) AS WA
            --,SUBMITTED_AT
        FROM
            ENTRIES AS E
            LEFT JOIN
                SUBMISSIONS AS S
            ON
                E.ENTRY_ID = S.ENTRY_ID
            AND E.CONTEST_ID = S.CONTEST_ID
            LEFT JOIN
                (
                    SELECT
                         PROBLEM_ID
                        ,ENTRY_ID
                        ,CONTEST_ID
                        ,SUBMITTED_AT
                    FROM
                        SUBMISSIONS
                    WHERE
                            CONTEST_ID ='2'
                        AND STATUS = 'AC'
                ) AS AC
            ON
                    S.PROBLEM_ID = AC.PROBLEM_ID
                AND S.ENTRY_ID = AC.ENTRY_ID
                AND S.CONTEST_ID = AC.CONTEST_ID
        WHERE
                E.CONTEST_ID ='2'
            AND S.SUBMITTED_AT BETWEEN E.STARTED_AT AND datetime(E.STARTED_AT, '+1 hours')
        GROUP BY
            E.USER_ID
    )