メモ：メモ一覧
更新

SELECT A.YMD ,A.BRAND_CODE ,AA.END_AMT ,AA.START_AMT ,AA.HIGH_AMT 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 INNER JOIN EveryDay4Data AA ON AA.BRAND_CODE = A.BRAND_CODE AND AA.TIME_NUM = A.TIME_NUM + 1 WHERE A.YMD BETWEEN '20230222' AND '20231101' AND A.END_AMT > 300 AND A.END_AMT > A.START_AMT AND B.END_AMT < B.START_AMT AND C.END_AMT < C.START_AMT AND D.END_AMT * 1.2 > C.HIGH_AMT AND D.END_AMT > D.START_AMT * 1.1