select SALES1.YEAR_MONTH,SALES1.MONTH_AMT,SALES2.CUML_AMT,SALES3.YEAR_MOVE_AMT
from 
(
  select SUBSTR(SALES_DATE,0,8) YEAR_MONTH,SUM(SALES_AMT) MONTH_AMT
  from SALES
  where SALES_DATE>='2023-01-01'
  and SALES_DATE<='2023-12-31'
  group by YEAR_MONTH
) SALES1,
(
  select SALE21.YEAR_MONTH,SUM(SALE22.CUML_AMT) CUML_AMT
  from 
  (select SUBSTR(SALES_DATE,0,8) YEAR_MONTH
  from SALES
   where SALES_DATE>='2023-01-01'
  and SALES_DATE<='2023-12-31'
  group by YEAR_MONTH) SALE21,

  (select SUBSTR(SALES_DATE,0,8) YEAR_MONTH,SUM(SALES_AMT) CUML_AMT
  from SALES
  where SALES_DATE>='2023-01-01'
  and SALES_DATE<='2023-12-31'
  group by YEAR_MONTH ) SALE22
  where SALE21.YEAR_MONTH>= SALE22.YEAR_MONTH
  group by SALE21.YEAR_MONTH
)SALES2,
(
  select SALE31.YEAR_MONTH,SUM(SALE32.YEAR_MOVE_AMT) YEAR_MOVE_AMT
  from 
  (select SUBSTR(SALES_DATE,0,8) YEAR_MONTH
  from SALES
   where SALES_DATE>='2023-01-01'
  and SALES_DATE<='2023-12-31'
  group by YEAR_MONTH) SALE31,

  (select SUBSTR(SALES_DATE,0,8) YEAR_MONTH,SUM(SALES_AMT) YEAR_MOVE_AMT
  from SALES
  where SALES_DATE>='2022-01-01'
  and SALES_DATE<='2023-12-31'
  group by YEAR_MONTH ) SALE32
  where date(SALE31.YEAR_MONTH||'-01','-11 months')<= date(SALE32.YEAR_MONTH||'-01')
  and SALE32.YEAR_MONTH <= SALE31.YEAR_MONTH
  group by SALE31.YEAR_MONTH 
)SALES3
where SALES1.YEAR_MONTH =  SALES2.YEAR_MONTH 
AND  SALES3.YEAR_MONTH =  SALES2.YEAR_MONTH