メモ：メモ一覧
更新

SELECT A.YMD ,A.BRAND_CODE ,A.END_AMT ,B.YMD AS MAX_YMD ,C.YMD AS MIN_YMD FROM EveryDay4Data A INNER JOIN TestEveryDay4Data03 B ON B.YMD = (select MAX(YMD) from TestEveryDay4Data03 Z WHERE Z.BRAND_CODE = A.BRAND_CODE AND Z.YMD < A.YMD) AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN TestEveryDay4Data04 C ON C.YMD = (select MAX(YMD) from TestEveryDay4Data04 Z WHERE Z.BRAND_CODE = A.BRAND_CODE AND Z.YMD < B.YMD) AND C.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4BoriData AA ON AA.YMD = A.YMD AND AA.BRAND_CODE = A.BRAND_CODE WHERE A.YMD = '20190222' AND A.END_AMT > 200 AND A.VOLUME > 100000000 / A.END_AMT AND A.LOW_AMT <= AA.move25 - (AA.SIGMA * 2) AND B.HIGH_AMT > C.HIGH_AMT * 1.3 AND A.LOW_AMT <= C.HIGH_AMT * 1.03 AND A.LOW_AMT >= C.HIGH_AMT * 0.99