メモ：メモ一覧
更新

SELECT A.YMD ,A.BRAND_CODE ,A.END_AMT ,A.VOLUME FROM EveryDay4Data A INNER JOIN EveryDay4Data B ON B.YMD = (SELECT Z.BEF_YMD FROM EigyoCalendar Z WHERE Z.YMD = A.YMD) AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data C ON C.YMD = (SELECT Z.BEF_YMD FROM EigyoCalendar Z WHERE Z.YMD = B.YMD) AND C.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data D ON D.YMD = (SELECT Z.BEF_YMD FROM EigyoCalendar Z WHERE Z.YMD = C.YMD) AND D.BRAND_CODE = A.BRAND_CODE INNER JOIN MoveAverage DD ON DD.YMD = D.YMD AND DD.BRAND_CODE = A.BRAND_CODE WHERE A.END_AMT > 300 AND A.YMD LIKE '201911%' AND A.VOLUME > (1000 / A.END_AMT) * 100000 AND B.END_AMT > A.END_AMT * 1.01 AND C.END_AMT > B.END_AMT * 1.01 AND D.END_AMT > C.END_AMT * 1.01 AND B.END_AMT < A.END_AMT * 1.4 AND C.END_AMT < B.END_AMT * 1.4 AND D.END_AMT < C.END_AMT * 1.4 AND DD.move25 > D.END_AMT