SELECT *, RANK() OVER(PARTITION BY E.ENTRY_ID ORDER BY S.POINT DESC) AS 順位, strftime('%s', S.SUBMITTED_AT) - strftime('%s', S.STARTED_AT) AS EX_TIME,  E.USER_ID, COUNT(STATUS = "WA" OR NULL) AS WRONG_ANS
FROM ENTRIES AS E
JOIN SUBMISSIONS AS S USING(USER_ID)
WHERE E.ENTRY_ID IS NOT NULL AND E.CONTEST_ID = "2" AND S.SUBMITTED_AT < "2022-07-20 18:00:00" AND S.POINT != 0
GROUP BY E.USER_ID