select 
substr(SALES_DATE,1,7) AS YEAR_MONTH
,SUM(CASE WHEN substr(SALES_DATE,1,7) IN substr(SALES_DATE,1,7) THEN SALES_AMT ELSE 0 END) AS MONTH_AMT
,SUM(CASE WHEN SALES_DATE BETWEEN DATE('2023-01-01') AND DATE(substr(SALES_DATE,1,7)||'-31') THEN SALES_AMT ELSE 0 END) AS  CUML_AMT
,SUM(CASE WHEN SALES_DATE BETWEEN DATE(DATE(substr(SALES_DATE,1,7)||'-01'),'start of year','-11 months') AND DATE(substr(SALES_DATE,1,7)||'-31') THEN SALES_AMT ELSE 0 END) AS  YEAR_MOVE_AMT
from SALES
WHERE UPDATED_NO IS NULL
GROUP BY 1 ORDER BY 1;