SELECT
	 DENSE_RANK () OVER(
		ORDER BY Result.TOTAL DESC
	 ) RANK
	,Result.User_ID USER_ID
	,Result.TOTAL AS POINT
	,Result.Elapsed + (5 * Result.WC)
	,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
;