SELECT 
1 AS RANK
,A.USER_ID
,A.POINT
,A.SUBMITTED_AT - B.STARTED_AT AS EX_TIME
,(SELECT COUNT(*) FROM SUBMISSIONS WHERE STATUS = 'WA') AS WRONG_ANS

FROM SUBMISSIONS A

LEFT OUTER JOIN ENTRIES B
ON A.USER_ID = B.USER_ID

WHERE 0 = 0
AND A.CONTEST_ID = 2
AND A.POINT <>  0

ORDER BY RANK,WRONG_ANS,A.USER_ID