メモ：メモ一覧
更新

SELECT A.YMD ,A.BRAND_CODE ,B.YMD AS 高値 ,D.YMD AS 安値 FROM EveryDay4Data A INNER JOIN EigyoCalendar AA ON AA.YMD = A.YMD -- 賃借銘柄 INNER JOIN RentalBrandList AX ON AX.BRAND_CODE = A.BRAND_CODE INNER JOIN TestEveryDay4Data03 B ON B.YMD = ( select MAX(Z.YMD) from TestEveryDay4Data03 Z where Z.YMD < AA.BEF_5YMD AND Z.YMD > AA.BEF_75YMD AND Z.BRAND_CODE = A.BRAND_CODE ) AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN TestEveryDay4Data04 D ON D.YMD = ( select MAX(Z.YMD) from TestEveryDay4Data04 Z where Z.YMD < AA.BEF_5YMD AND Z.YMD > AA.BEF_75YMD AND Z.BRAND_CODE = A.BRAND_CODE ) AND D.BRAND_CODE = A.BRAND_CODE WHERE A.YMD BETWEEN '20180801' AND '20180830' AND D.YMD < B.YMD AND B.HIGH_AMT > D.HIGH_AMT * 1.15 AND A.LOW_AMT > D.HIGH_AMT AND A.LOW_AMT < D.HIGH_AMT * 1.05