我试图统计过去七天内连续两天订购产品的次数。我试图在CASE WHEN中实现IN条件，但得到以下错误：Comparison operator IN not valid
我使用的是DB2
以下是我尝试过的方法：

WITH CTE AS (
            SELECT ALLPIC, COUNT(DISTINCT(PAL.CODPRO)) AS NBREFSSTOCKS
            FROM FGE50NEUV1.GEPAL AS PAL INNER JOIN FGE50NEUV1.GEPIC AS PIC ON PAL.CODPRO = PIC.CODPRO
            GROUP BY ALLPIC
        ),
        CTE2 AS (
            SELECT ALLSTS AS ALLPIC, COUNT(DISTINCT CASE WHEN DATPRB1 = ` + dateWMS() + ` THEN CODPRO END) AS NBREFSCDE,
            COUNT(
                DISTINCT CASE WHEN (
                    CODPRO IN (SELECT DISTINCT(CODPRO) FROM FGE50NEUV1.GESUPD WHERE DATPRB1 = 20221027) 
                    AND CODPRO IN (SELECT DISTINCT(CODPRO) FROM FGE50NEUV1.GESUPD WHERE DATPRB1 = 20221028) 
                    THEN CODPRO END
                )
            ) AS NBCOMMUNVEILLE,
            COUNT(
                DISTINCT CASE WHEN (
                    CODPRO IN (SELECT DISTINCT(CODPRO) FROM FGE50NEUV1.GESUPD WHERE DATPRB1 = 20221026) 
                    AND CODPRO IN (SELECT DISTINCT(CODPRO) FROM FGE50NEUV1.GESUPD WHERE DATPRB1 = 20221027) 
                    THEN CODPRO END
                )
            ) AS NBCOMMUNJM2

            FROM FGE50NEUV1.GESUPD AS SUP
            GROUP BY ALLSTS
        )

        SELECT * FROM CTE INNER JOIN CTE2 ON CTE.ALLPIC = CTE2.ALLPIC ORDER BY CTE.ALLPIC