メモ：メモ一覧
更新

select A.* from EveryDay4Data A inner join EveryDay4Data B ON B.BRAND_CODE = A.BRAND_CODE AND B.TIME_NUM = A.TIME_NUM - 1 AND B.START_AMT < B.END_AMT AND A.END_AMT < B.END_AMT * 1.03 inner join EveryDay4Data C ON C.BRAND_CODE = B.BRAND_CODE AND C.TIME_NUM = B.TIME_NUM - 1 AND C.START_AMT < C.END_AMT AND B.END_AMT < C.END_AMT * 1.03 inner join EveryDay4Data D ON D.BRAND_CODE = C.BRAND_CODE AND D.TIME_NUM = C.TIME_NUM - 1 AND D.START_AMT < D.END_AMT AND C.END_AMT < D.END_AMT * 1.03 inner join EveryDay4Data E ON E.BRAND_CODE = D.BRAND_CODE AND E.TIME_NUM = D.TIME_NUM - 1 AND E.START_AMT < E.END_AMT AND D.END_AMT < E.END_AMT * 1.03 WHERE A.YMD BETWEEN '20230301' AND '20230401' AND A.VOLUME > 1000000000 / A.END_AMT AND E.move5 < E.move25 AND E.move25 < E.move75