ソースコード
SELECT  PROCESS_ID AS PROCESS,
        COUNT(SESSION_ID) AS CNT
FROM    (
            SELECT  SESSION_ID,
                    PROCESS_ID,
                    USER_ID,
                    STEPOUT,
                    COUNT,
                    COUNT(PROCESS_ID) OVER(partition by SESSION_ID order by EX_TIMESTAMP) AS COUNT2
            FROM    (
                        SELECT  SESSION_ID,
                                PROCESS_ID,
                                USER_ID,
                                EX_TIMESTAMP,
                                SUBSTR(PROCESS_ID, 5, 1) AS STEPOUT,
                                COUNT(PROCESS_ID) OVER(partition by SESSION_ID order by EX_TIMESTAMP) AS COUNT
                        FROM    PROCESS_LOG
                    ) 
            WHERE   CAST(COUNT as string) = CAST(STEPOUT AS string)
        ) 
WHERE COUNT = COUNT2
GROUP BY PROCESS_ID
ORDER BY PROCESS_ID ASC
提出情報
提出日時2023/12/20 11:09:14
コンテスト第10回 SQLコンテスト
問題顧客行動分析
受験者korogu
状態 (詳細)WA
(Wrong Answer: 誤答)
メモリ使用量87 MB
メッセージ
テストケース(通過数/総数)
3/4
状態
メモリ使用量
データパターン1
AC
85 MB
データパターン2
AC
83 MB
データパターン3
AC
87 MB
データパターン4
WA
85 MB