メモ：メモ一覧
更新

SELECT A.* FROM EveryDay4Data A INNER JOIN EigyoCalendar AA ON AA.BEF_5YMD = A.YMD INNER JOIN MoveAverage AB ON AB.YMD = A.YMD AND AB.BRAND_CODE = A.BRAND_CODE LEFT JOIN EveryDay4Data B ON B.BRAND_CODE = A.BRAND_CODE AND B.YMD BETWEEN A.YMD AND AA.YMD AND B.END_AMT < (A.END_AMT + A.START_AMT) / 2 WHERE A.YMD BETWEEN '20180501' AND '20180515' AND A.END_AMT > A.START_AMT * 1.1 AND AB.move75 > AB.move25 AND A.END_AMT > AB.move75 AND A.START_AMT < AB.move75 AND A.END_AMT > 100 AND B.BRAND_CODE IS NULL