WITH
RAW_TIME_tbl AS(
SELECT ENTRIES.USER_ID, CAST((julianday(MAX(SUBMISSIONS.SUBMITTED_AT)) - julianday(ENTRIES.STARTED_AT)) * 86400 AS INTEGER) AS RAW_TIME FROM 
ENTRIES INNER JOIN SUBMISSIONS on ENTRIES.ENTRY_ID = SUBMISSIONS.ENTRY_ID
GROUP BY ENTRIES.USER_ID
),
MISS_CNT_tbl AS
(
SELECT SUBMISSIONS.USER_ID as user_id , SUBMISSIONS.PROBLEM_ID as problem_id
FROM ENTRIES INNER JOIN SUBMISSIONS on ENTRIES.ENTRY_ID = SUBMISSIONS.ENTRY_ID
GROUP BY SUBMISSIONS.PROBLEM_ID,SUBMISSIONS.USER_ID
HAVING SUBMISSIONS.STATUS IN("AC") 
)
SELECT MISS_CNT_tbl.problem_id FROM MISS_CNT_tbl
-- SELECT RAW_TIME_tbl.USER_ID,RAW_TIME_tbl.RAW_TIME FROM RAW_TIME_tbl

-- 素の解答時間を求める
-- 各問題の誤答数を求める
-- 最終的にACしたやつの提出数-1すればいい
-- スコアの総和を計算する
-- それらをもとにランキングを構成する