メモ：メモ一覧
更新

-- 安値1%付近 SELECT * FROM ( SELECT A.YM ,A.BRAND_CODE ,A.LOW_AMT ,TRUNCATE(((B.LOW_AMT - C.LOW_AMT) / (BB.TIME_NUM - CC.TIME_NUM)) * (A.TIME_NUM - BB.TIME_NUM) + B.LOW_AMT, 2) AS LINE_AMT FROM EveryMonth4Data A INNER JOIN EveryMonth4LowData B ON B.BRAND_CODE = A.BRAND_CODE AND B.YM = ( SELECT MAX(Z.YM) FROM EveryMonth4LowData Z WHERE Z.BRAND_CODE = A.BRAND_CODE AND Z.YM < A.YM ) INNER JOIN EveryMonth4LowData C ON C.BRAND_CODE = A.BRAND_CODE AND C.TIME_NUM = B.TIME_NUM - 1 INNER JOIN EveryMonth4Data BB ON BB.BRAND_CODE = A.BRAND_CODE AND BB.YM = B.YM INNER JOIN EveryMonth4Data CC ON CC.BRAND_CODE = A.BRAND_CODE AND CC.YM = C.YM WHERE A.YM = '202104' ) S WHERE S.LINE_AMT < S.LOW_AMT AND (S.LOW_AMT - S.LINE_AMT) / S.LOW_AMT < 0.01