SELECT *, RANK() OVER (PARTITION BY USER_ID ORDER BY POINT DESC, EX_TIME DESC) AS RANK FROM (
SELECT
SUBMISSIONS.USER_ID, 
SUBMISSIONS.CONTEST_ID, 
SUM(POINT) OVER (PARTITION BY SUBMISSIONS.USER_ID) AS POINT, 
MAX(SUBMITTED_AT) OVER (PARTITION BY SUBMISSIONS.USER_ID) - STARTED_AT AS EX_TIME,
COUNT(SUBMITTED_AT) OVER (PARTITION BY SUBMISSIONS.USER_ID)
FROM SUBMISSIONS JOIN ENTRIES USING(ENTRY_ID)
WHERE SUBMISSIONS.CONTEST_ID = 2
) 
WHERE POINT > 0
ORDER BY RANK