SELECT 
  RANK() OVER(ORDER BY SUM(a.POINT) DESC) AS RANK,
  b.USER_ID AS USER_ID,
  SUM(a.POINT) AS POINT,
  ( 
  SELECT 
  (
    strftime('%s', 
      CASE
        WHEN STATUS="AC" THEN MAX(d.SUBMITTED_AT)
        WHEN STATUS="WA" THEN MAX(d.SUBMITTED_AT)
        WHEN STATUS="RE" THEN MAX(d.SUBMITTED_AT) 
      ELSE 0
      END
    ) - 
    CASE
        WHEN STATUS="AC" THEN strftime('%s', c.STARTED_AT)
        WHEN STATUS="WA" THEN strftime('%s', c.STARTED_AT)
        WHEN STATUS="RE" THEN strftime('%s', c.STARTED_AT)
      ELSE 0
      END
    
  
    ) 
    + 300 * (SUM(CASE WHEN STATUS="WA" THEN 1 ELSE 0 END)
    )
FROM ENTRIES AS c
INNER JOIN SUBMISSIONS AS d ON d.ENTRY_ID = c.ENTRY_ID
WHERE d.USER_ID = a.USER_ID AND c.CONTEST_ID = 2 AND c.ENTRY_ID IS NOT NULL
    GROUP BY d.USER_ID, d.CONTEST_ID
    ) AS EX_TIME,
  ( 
  SELECT 
    (
    SUM(CASE WHEN STATUS="WA" THEN 1 ELSE 0 END))
FROM ENTRIES AS c
INNER JOIN SUBMISSIONS AS d ON d.ENTRY_ID = c.ENTRY_ID
WHERE d.USER_ID = a.USER_ID AND c.CONTEST_ID = 2 AND c.ENTRY_ID IS NOT NULL
    GROUP BY d.USER_ID, d.CONTEST_ID
    ) AS WRONG_ANS
    
FROM ENTRIES AS b
INNER JOIN SUBMISSIONS AS a ON a.ENTRY_ID = b.ENTRY_ID
  AND a.CONTEST_ID = b.CONTEST_ID 
  AND a.USER_ID = b.USER_ID
WHERE a.CONTEST_ID = 2 AND a.ENTRY_ID IS NOT NULL
GROUP BY b.USER_ID, a.CONTEST_ID
ORDER BY
    RANK ASC
    , WRONG_ANS ASC
    , USER_ID ASC;