DECLARE @tbl TABLE
([MONTH] INT, [COUNT] INT, code VARCHAR(30)
)
INSERT INTO @tbl
SELECT 6, 8425, 'DELIVERY' UNION ALL
SELECT 6, 20, 'CANCELLED'

-- option 1: PIVOT
SELECT [MONTH],[DELIVERY], [CANCELLED]
FROM 
(
	SELECT [MONTH] , [COUNT] , code 
	FROM @tbl
) p
PIVOT
(
	SUM ([COUNT]) 
	FOR code IN	( [DELIVERY], [CANCELLED])
) AS pvt

-- option 2: "classic" CASE statement
SELECT 
	[MONTH],
	SUM(CASE WHEN code ='DELIVERY' THEN [COUNT] ELSE 0 END) AS [DELIVERY], 
	SUM(CASE WHEN code ='CANCELLED' THEN [COUNT] ELSE 0 END) AS [CANCELLED]
FROM @tbl
GROUP BY [MONTH]