メモ：メモ一覧
更新

SELECT A.* FROM EveryDay4Data A INNER JOIN EigyoCalendar AA ON AA.YMD = A.YMD INNER JOIN EveryDay4Data 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 INNER JOIN EveryDay4BoriData BX ON BX.YMD = B.YMD AND BX.BRAND_CODE = B.BRAND_CODE WHERE A.YMD = '20190222' AND A.END_AMT > 300 AND B.LOW_AMT > BX.move25 - (BX.SIGMA * 2) AND A.LOW_AMT <= AX.move25 - (AX.SIGMA * 3) AND A.VOLUME > B.VOLUME AND AX.SIGMA >= A.END_AMT * 0.05 AND A.VOLUME > 100000000 / A.END_AMT