Hi makumbi,
Use the following query to calculate the Week number.
DECLARE @Date DATETIME
SET @Date = '12/01/2023'
SELECT CONCAT('wk', (DATEPART(WEEK, @Date) - DATEPART(WEEK, DATEADD(MM, DATEDIFF(MM,0,@Date), 0))+ 1)) AS Week_Number
Then pivot query to for displaying the result.
For more details refer below link.
Convert Rows To Columns and Calculate Sum using dynamic Pivot query in SQL Server