メモ：メモ一覧
更新

SELECT S.YMD ,S.BRAND_CODE ,(MAX(S.HIGH_AMT) * 0.382) + (MAX(S.MIN_AMT) * 0.618) AS FIBO38 ,MIN(X.LOW_AMT) AS LOW_AMT ,MAX(S.RATE) AS RATE FROM ( SELECT A.YMD ,A.BRAND_CODE ,(CASE WHEN A.HIGH_AMT > B.HIGH_AMT THEN A.HIGH_AMT ELSE B.HIGH_AMT END ) AS HIGH_AMT ,A.MIN_AMT ,A.RATE FROM DayBrandList A INNER JOIN EveryDay4Data B ON B.BRAND_CODE = A.BRAND_CODE AND B.YMD = (select Z.YMD from EigyoCalendar Z where Z.BEF_YMD = A.YMD) INNER JOIN EveryDay4Data C ON C.BRAND_CODE = A.BRAND_CODE AND C.YMD = (select MAX(Z.YMD) from EigyoCalendar Z) LEFT JOIN TestEveryDay4Data03 G ON G.BRAND_CODE = A.BRAND_CODE AND G.YMD > B.YMD WHERE A.YMD >= '20190308' AND G.YMD IS NULL ) S INNER JOIN EveryDay4Data X ON X.BRAND_CODE = S.BRAND_CODE AND X.YMD > S.YMD GROUP BY S.YMD ,S.BRAND_CODE