メモ:
メモ一覧
更新
SELECT A.* FROM EveryDay4Data A INNER JOIN EigyoCalendar AA ON AA.YMD = A.YMD INNER JOIN EveryDay4BoriData B ON B.YMD = AA.BEF_YMD AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4BoriData AX ON AX.YMD = A.YMD AND AX.BRAND_CODE = A.BRAND_CODE WHERE A.YMD BETWEEN '20190201' AND '20190315' AND A.END_AMT > 200 AND A.LOW_AMT < (AX.move25 - AX.SIGMA * 3) AND A.HIGH_AMT <> A.LOW_AMT AND AX.SIGMA BETWEEN B.SIGMA * 0.99 AND B.SIGMA * 1.01 AND 0.01 < AX.SIGMA / A.END_AMT