メモ：メモ一覧
更新

-- move25 以下からmove5↑まで安値更新されている 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 Z.BEF_YMD from EigyoCalendar Z where Z.YMD = A.YMD) AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN MoveAverage BB ON BB.YMD = B.YMD AND BB.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 MoveAverage CC ON CC.YMD = C.YMD AND CC.BRAND_CODE = A.BRAND_CODE WHERE AA.YMD BETWEEN '20180501' AND '20180601' AND A.END_AMT > A.START_AMT AND A.END_AMT > AA.move5 AND AA.move5 > AA.move25 AND AA.move25 > AA.move75 AND AA.move5 <= A.LOW_AMT * 1.01 AND AA.move5 >= A.LOW_AMT * 0.99 AND A.LOW_AMT > B.LOW_AMT AND B.END_AMT > BB.move5 AND BB.move5 > BB.move25 AND BB.move25 > BB.move75 AND BB.move5 <= B.LOW_AMT * 1.01 AND BB.move5 >= B.LOW_AMT * 0.99 AND A.END_AMT < A.BEFORE_AMT * 1.05 AND C.LOW_AMT < CC.move5 AND C.LOW_AMT < CC.move25 AND C.HIGH_AMT > CC.move5 AND C.HIGH_AMT > CC.move25