SELECT
    	 RANK () OVER(
    		ORDER BY Result.TOTAL DESC, Result.Elapsed + (5 * Result.WC), Result.WC
    	 ) RANK
    	,Result.User_ID USER_ID
    	,Result.TOTAL AS POINT
    	,Result.Elapsed + (5 * Result.WC) AS EX_TIME
    	,Result.WC AS WRONG_ANS
    FROM
    (
    select
    	S.User_ID AS User_ID
    	 ,SUM(
    		CASE	
    			WHEN S.Status <> 'AC' AND Submitted_at < EX_TIME_T.Last_AC_Submitted_Time THEN 1
    			ELSE 0
    		END
    	 ) AS WC
    	, SUM(
    		CASE
    			WHEN	
    				S.Status = 'AC' THEN S.POINT
    			ELSE 0
    		END) AS TOTAL
    	,EX_TIME_T.Elapsed
    FROM
    	Entries E
    INNER JOIN
    	SubMissions S
    INNER JOIN
    (
    select
    	 ROUND( (JULIANDAY(MAX(S.Submitted_at)) -  JULIANDAY(E.Started_at)) * 86400) Elapsed
    	 ,E.User_ID User_ID
    	,MAX(S.Submitted_at) Last_AC_Submitted_Time
    FROM
    	Entries E
    INNER JOIN
    	SubMissions S
    ON
    	E.Entry_ID = S.Entry_ID
    WHERE
    	Status = 'AC'
    AND
    	S.CONTEST_ID = '2'
    GROUP BY
    	E.User_ID
    ) EX_TIME_T
    ON
    	E.Entry_ID = S.Entry_ID
    AND
    	S.User_ID = EX_TIME_T.User_ID
    WHERE
    	S.CONTEST_ID = '2'
    GROUP BY 
    	S.User_ID
    ) Result
    ORDER BY
    	RANK, WRONG_ANS, User_ID
    ;