SELECT 
  RANK() OVER(ORDER BY SUM(a.POINT) DESC) AS RANK,
  b.USER_ID AS USER_ID,
  SUM(a.POINT) AS POINT,
  ( 

  strftime('%s', MAX(a.SUBMITTED_AT)) - strftime('%s', b.STARTED_AT)

    ) 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
-- , PROBLEM_ID
ORDER BY
    RANK ASC
    , WRONG_ANS ASC
    , USER_ID ASC;