メモ：メモ一覧
更新

SELECT S.YMD ,S.BRAND_CODE ,I.BRAND_NAME ,S.END_AMT ,S.VOLUME ,C.START_AMT AS AFT_START ,C.HIGH_AMT AS AFT_HIGH ,C.END_AMT AS AFT_END ,C.LOW_AMT AS AFT_LOW ,(select MAX(Z.HIGH_AMT) from EveryDay4Data Z where Z.BRAND_CODE = S.BRAND_CODE and Z.TIME_NUM BETWEEN S.TIME_NUM - 100 AND S.TIME_NUM - 1 ) AS HIGH FROM ( -- 寄らずのストップ SELECT '0' AS PATTERN_CD ,A.YMD ,A.BRAND_CODE ,A.END_AMT ,A.VOLUME ,A.TIME_NUM ,'' AS MOKUHYO FROM EveryDay4Data A WHERE A.YMD BETWEEN '20240110' AND '20240514' AND A.HIGH_AMT = A.LOW_AMT AND A.END_AMT > A.BEFORE_AMT * 1.15 AND A.END_AMT > 300 ) S LEFT JOIN BrandMaster I ON I.BRAND_CODE = S.BRAND_CODE LEFT JOIN EveryDay4Data C ON C.BRAND_CODE = S.BRAND_CODE AND C.TIME_NUM = S.TIME_NUM + 1 WHERE S.END_AMT < (select MAX(Z.HIGH_AMT) from EveryDay4Data Z where Z.BRAND_CODE = S.BRAND_CODE and Z.TIME_NUM BETWEEN S.TIME_NUM - 100 AND S.TIME_NUM - 1 ) ORDER BY S.YMD