メモ：メモ一覧
更新

-- 横横が続いてそう SELECT A.* FROM EveryDay4Data S INNER JOIN ( SELECT A.YMD,A.BRAND_CODE, A.END_AMT FROM EveryDay4Data A INNER JOIN EveryDay4Data B ON B.TIME_NUM = A.TIME_NUM - 125 AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data C ON C.TIME_NUM = A.TIME_NUM - 75 AND C.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data D ON D.TIME_NUM = A.TIME_NUM - 25 AND D.BRAND_CODE = A.BRAND_CODE WHERE A.YMD BETWEEN '20210201' AND '20210201' AND A.move75 BETWEEN A.move25 * 0.98 AND A.move25 * 1.02 AND B.move75 BETWEEN B.move25 * 0.98 AND B.move25 * 1.02 AND C.move75 BETWEEN C.move25 * 0.98 AND C.move25 * 1.02 AND D.move75 BETWEEN D.move25 * 0.98 AND D.move25 * 1.02 ) T ON T.BRAND_CODE = S.BRAND_CODE WHERE S.YMD BETWEEN '20210201' AND '20210208' AND S.END_AMT >= T.END_AMT * 1.05