メモ：メモ一覧
更新

SELECT BB.YMD AS BBBBBBB ,A.* FROM MoveAverage A INNER JOIN EveryDay4Data AX ON AX.BRAND_CODE = A.BRAND_CODE AND AX.YMD = A.YMD INNER JOIN EigyoCalendar AA ON AA.YMD = A.YMD INNER JOIN EigyoCalendar BB ON BB.YMD = AA.BEF_75YMD INNER JOIN MoveAverage B ON B.BRAND_CODE = A.BRAND_CODE AND B.YMD = BB.YMD LEFT JOIN EveryDay4Data C ON C.BRAND_CODE = A.BRAND_CODE AND C.YMD BETWEEN BB.BEF_75YMD AND BB.YMD AND C.BEFORE_AMT > C.END_AMT * 1.4 WHERE A.YMD LIKE '202001%' AND B.move75 > B.move25 * 1.2 AND A.move75 < A.move25 * 1.05 AND A.move75 > A.move25 AND C.YMD IS NULL AND NOT A.BRAND_CODE LIKE '1%' AND AX.VOLUME > 10000000 / AX.END_AMT