with table1 as (
    select
        strftime('%Y-%m', SALES_DATE) as YEAR_MONTH,
        sum(SALES_AMT) as MONTH_AMT
    from 
        SALES
    where 
        SALES_DATE >= "2022-01-01"
        and UPDATED_NO is null
    group by 
        YEAR_MONTH
),
table2 as (
    select 
        table1.*,
        sum(MONTH_AMT) over(
            order by YEAR_MONTH
            rows between 11 PRECEDING and current row
        ) as YEAR_MOVE_AMT
    from 
        table1
)


select 
    table2.*,
    sum(MONTH_AMT) over(
        order by YEAR_MONTH
        rows between unbounded preceding and current row
    ) as CUML_AMT
from 
    table2
where
    YEAR_MONTH between "2023-01" and "2023-12"
order by 
    YEAR_MONTH
-- 集計した移動年計金額 as YEAR_MOVE_AMT


-- group by YEAR_MONTH