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', 
  
  MAX(d.SUBMITTED_AT)
  ) - strftime('%s', c.STARTED_AT)
  
  ) 
    + 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
-- , PROBLEM_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
-- , PROBLEM_ID
ORDER BY
    RANK ASC
    , WRONG_ANS ASC
    , USER_ID ASC;