メモ：メモ一覧
更新

SELECT A.* FROM EveryDay4Data A INNER JOIN EigyoCalendar AA ON AA.YMD = A.YMD INNER JOIN MoveAverage AM ON AM.YMD = A.YMD AND AM.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data B ON B.YMD = AA.BEF_YMD AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data C ON C.YMD = (select Z.YMD from EigyoCalendar Z where Z.BEF_YMD = A.YMD) AND C.BRAND_CODE = A.BRAND_CODE WHERE A.YMD BETWEEN '20190101' AND '20190131' AND A.END_AMT > 200 AND AM.move75 > AM.move25 AND AM.move25 > AM.move5 AND A.END_AMT BETWEEN A.START_AMT * 0.99 AND A.START_AMT * 1.01 AND A.HIGH_AMT < B.LOW_AMT AND A.VOLUME > 50000000 / A.END_AMT AND C.LOW_AMT > A.HIGH_AMT AND NOT EXISTS ( select * from EveryDay4Data Z where Z.BRAND_CODE = A.BRAND_CODE AND Z.YMD BETWEEN AA.BEF_25YMD AND AA.BEF_YMD AND Z.LOW_AMT < A.HIGH_AMT )