メモ：メモ一覧
更新

SELECT SUM( (AX.END_AMT - A.END_AMT) * (TRUNCATE(10000 / A.END_AMT , 0) * 100) ) AS TOTAL FROM EveryDay4Data A INNER JOIN EveryDay4Data B ON B.YMD = (SELECT Z.BEF_YMD FROM EigyoCalendar Z WHERE Z.YMD = A.YMD) AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data C ON C.YMD = (SELECT Z.BEF_YMD FROM EigyoCalendar Z WHERE Z.YMD = B.YMD) AND C.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data D ON D.YMD = (SELECT Z.BEF_YMD FROM EigyoCalendar Z WHERE Z.YMD = C.YMD) AND D.BRAND_CODE = A.BRAND_CODE INNER JOIN EveryDay4Data AX ON AX.YMD = (SELECT MAX(Z.YMD) FROM EigyoCalendar Z WHERE Z.BEF_YMD = A.YMD) AND AX.BRAND_CODE = A.BRAND_CODE INNER JOIN MoveAverage AA ON AA.YMD = A.YMD AND AA.BRAND_CODE = A.BRAND_CODE INNER JOIN MoveAverage BB ON BB.YMD = B.YMD AND BB.BRAND_CODE = A.BRAND_CODE INNER JOIN MoveAverage CC ON CC.YMD = C.YMD AND CC.BRAND_CODE = A.BRAND_CODE INNER JOIN MoveAverage DD ON DD.YMD = D.YMD AND DD.BRAND_CODE = A.BRAND_CODE WHERE A.END_AMT > 300 AND A.YMD LIKE '2017%' AND B.VOLUME > (1000 / A.END_AMT) * 100000 AND B.END_AMT < B.BEFORE_AMT AND C.END_AMT < C.BEFORE_AMT AND D.END_AMT < D.BEFORE_AMT AND B.END_AMT < A.END_AMT * 1.4 AND C.END_AMT < B.END_AMT * 1.4 AND D.END_AMT < C.END_AMT * 1.4 AND A.LOW_AMT < B.END_AMT * 0.95 AND BB.move25 < BB.move75 AND BB.move5 < BB.move25 AND CC.move25 < CC.move75 AND CC.move5 < CC.move25 AND DD.move25 < DD.move75 AND DD.move5 < DD.move25