メモ：メモ一覧
更新

SELECT A.* FROM EveryDay4Data A INNER JOIN EveryDay4Data B ON B.BRAND_CODE = A.BRAND_CODE AND B.YMD = (select Z.BEF_YMD from EigyoCalendar Z where Z.YMD = A.YMD) INNER JOIN EveryDay4Data C ON C.BRAND_CODE = A.BRAND_CODE AND C.YMD = (select Z.YMD from EigyoCalendar Z where Z.BEF_YMD = A.YMD) INNER JOIN EveryDay4Data G ON G.BRAND_CODE = A.BRAND_CODE AND G.YMD = (select Z.BEF_5YMD from EigyoCalendar Z where Z.YMD = A.YMD) WHERE A.YMD LIKE '202103%' AND A.HIGH_AMT < B.LOW_AMT AND A.HIGH_AMT < C.LOW_AMT AND A.HIGH_AMT < G.LOW_AMT AND A.END_AMT BETWEEN A.START_AMT * 0.99 AND A.START_AMT * 1.01 AND A.VOLUME > 100000000 / A.END_AMT AND A.END_AMT > 200 AND B.START_AMT < A.END_AMT * 1.6 AND A.move5 < A.move25 AND A.move25 < A.move75