with temp1 as (
    select
        strftime('%Y-%m', date(sales_date)) as year_month
        , sum(sales_amt) as month_amt
    from sales
    where updated_no is null
    group by year_month
), 
temp2 as (
    select 
        year_month
        , month_amt
        , sum(month_amt) over (
            order by year_month rows between 11 preceding and current row
        ) as year_move_amt
    from temp1
),
temp3 as (
    select 
        year_month
        , month_amt
        , sum(month_amt) over (order by year_month) as cuml_amt
        , year_move_amt
    from temp2
    where year_month between '2023-01' and '2023-12'
)
select
    year_month as 'YEAR_MONTH'
    , month_amt as 'MONTH_AMT'
    , cuml_amt as 'CUML_AMT'
    , year_move_amt as 'YEAR_MOVE_AMT'
from temp3
order by year_month