メモ：メモ一覧
更新

SELECT A.* FROM EveryDay4Data A INNER JOIN MoveAverage AA ON AA.YMD = A.YMD AND AA.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data B ON B.YMD = (select MAX(Z.YMD) from EigyoCalendar Z where Z.BEF_YMD = A.YMD) AND B.BRAND_CODE = A.BRAND_CODE WHERE A.YMD BETWEEN '20180501' AND '20180601' AND A.HIGH_AMT > A.END_AMT * 1.03 AND A.END_AMT BETWEEN A.START_AMT * 0.99 AND A.START_AMT * 1.01 AND A.END_AMT < AA.move5 AND A.END_AMT < AA.move25 AND A.END_AMT < AA.move75 AND A.END_AMT BETWEEN A.LOW_AMT * 0.99 AND A.LOW_AMT * 1.01 AND A.END_AMT BETWEEN A.BEFORE_AMT * 0.99 AND A.BEFORE_AMT * 1.01 AND B.START_AMT BETWEEN B.BEFORE_AMT * 0.99 AND B.BEFORE_AMT * 1.01 AND B.END_AMT > B.BEFORE_AMT AND B.LOW_AMT >= A.LOW_AMT * 0.99 AND B.END_AMT > B.START_AMT AND A.END_AMT > 100 AND A.VOLUME > 30000000 / A.END_AMT