メモ：メモ一覧
更新

SELECT DISTINCT A.BRAND_CODE FROM EveryDay4Data A INNER JOIN EveryDay4Data B ON B.BRAND_CODE = A.BRAND_CODE AND B.TIME_NUM = A.TIME_NUM - 1 INNER JOIN EveryDay4Data C ON C.BRAND_CODE = A.BRAND_CODE AND C.TIME_NUM = A.TIME_NUM - 2 WHERE A.YMD BETWEEN '20210301' AND '20210312' AND A.END_AMT > 200 AND A.LOW_AMT < A.move25 - (A.SIGMA * 3) AND B.LOW_AMT < B.move25 - (B.SIGMA * 3) AND C.LOW_AMT < C.move25 - (C.SIGMA * 3) AND A.LOW_AMT > 0 AND B.LOW_AMT > 0 AND C.LOW_AMT > 0