anibihakeem

SELECT
    ProductID,
    SalesDate,
    OrderQty,
    SUM(OrderQty) OVER (
        ORDER BY SalesDate
        ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING
    ) AS RollingSumOrderQty
FROM sales_data
ORDER BY ProductID, SalesDate;

anibihakeem

SELECT 
	FORMAT(SalesDate,'MMM') AS Month,
	Amount,
	AVG(Amount)OVER(PARTITION BY DATEPART(Month,SalesDate)) AS Avg_amount_per_transaction
FROM sales_data