Statistic query by week in T-SQL

 

SELECT 
    DATEPART(YEAR, CreateTime) AS 'Year',
    DATEPART(week,CreateTime) AS 'Week',
    MIN(DATEADD(week,DATEDIFF(week,0,CreateTime),0)) AS 'Week Date',
    SUM(COALESCE(Amount,0)) AS 'Order Amount',
    SUM(COALESCE(ModifiedAmount,0)) AS 'Modified Amount'
FROM dbo.T_Order(NOLOCK)
WHERE OrderStatus =1 OR OrderStatus =3
GROUP BY DATEPART(YEAR, CreateTime),DATEPART(week,CreateTime)
ORDER BY DATEPART(YEAR, CreateTime),DATEPART(week,CreateTime)