メモ：メモ一覧
更新

SELECT A.* FROM EveryDay4Data A INNER JOIN EveryDay4Data B ON B.BRAND_CODE = A.BRAND_CODE AND B.TIME_NUM = A.TIME_NUM - 1 INNER JOIN EveryDay4Data C ON C.BRAND_CODE = A.BRAND_CODE AND C.TIME_NUM = A.TIME_NUM - 2 INNER JOIN EveryDay4Data D ON D.BRAND_CODE = A.BRAND_CODE AND D.TIME_NUM = A.TIME_NUM - 3 WHERE A.YMD = '20250324' AND A.END_AMT > 300 AND (B.VOLUME + A.VOLUME + C.VOLUME + D.VOLUME) / 4 > 1000000000 / A.END_AMT AND (B.END_AMT + C.END_AMT + D.END_AMT) / 3 > A.move25 + (A.SIGMA) AND (B.END_AMT + C.END_AMT + D.END_AMT) / 3 <= A.move25 + (A.SIGMA * 2) AND A.HIGH_AMT <= A.move25 + (A.SIGMA * 2.5) AND ( B.LOW_AMT < B.move25 + (B.SIGMA) OR B.HIGH_AMT > B.move25 + (B.SIGMA * 2) OR C.LOW_AMT < C.move25 + (C.SIGMA) OR C.HIGH_AMT > C.move25 + (C.SIGMA * 2) OR D.LOW_AMT < D.move25 + (D.SIGMA) OR D.HIGH_AMT > D.move25 + (D.SIGMA * 2) )