メモ：メモ一覧
更新

-- 25平均にぶつかる SELECT A.* FROM EveryDay4Data A LEFT JOIN EveryDay4Data B ON B.BRAND_CODE = A.BRAND_CODE AND B.TIME_NUM BETWEEN A.TIME_NUM - 25 AND A.TIME_NUM - 1 AND B.move25 > B.LOW_AMT WHERE A.YMD = '20210325' AND A.move25 > A.LOW_AMT AND B.BRAND_CODE IS NULL