with tmp as (
select
    *
from sales
where
    UPDATED_NO is null
),tmp_monthly as (
select
    substring(date(sales_date),1, 4) as YEAR,
    substring(date(sales_date),1, 7) as YEAR_MONTH,
    sum(sales_amt) as MONTH_AMT
from tmp
group by
    substring(date(sales_date),1, 7)
),tmp_cum as (
select
    *,
    sum(MONTH_AMT) over(partition by YEAR order by YEAR_MONTH rows unbounded preceding) as CUML_AMT
from tmp_monthly
),tmp_move_avg as (
select
    *,
    sum(sum(MONTH_AMT)) over(order by YEAR_MONTH rows between 11 preceding and current row) as YEAR_MOVE_AMT
from tmp_cum
group by
    YEAR_MONTH
)
select
    YEAR_MONTH,
    MONTH_AMT,
    CUML_AMT,
    YEAR_MOVE_AMT
from tmp_move_avg
where
    YEAR = '2023'
order by
    YEAR_MONTH
;