メモ：メモ一覧
更新

SELECT B.MONEY ,floor(SUM(CASE WHEN A.END_AMT BETWEEN B.MONEY AND B.MONEY + 9999 THEN A.VOLUME ELSE 0 END)) AS cnt FROM EveryDay1mData A INNER JOIN ( select TIME_NUM * 10000 + 2900000 AS MONEY -- 290万から200万幅 from EveryDay1mData where TIME_NUM BETWEEN 1 AND 200 ) B ON 1 = 1 INNER JOIN EveryDay1mData C ON C.YMD = '20220613' AND C.TIME = '23:59' WHERE A.TIME_NUM BETWEEN C.TIME_NUM - 10080 AND C.TIME_NUM GROUP BY B.MONEY