DECLARE	@Sample TABLE (Name VARCHAR(10), Status INT, Month INT)

INSERT	@Sample
SELECT	'apple', 1, 1 UNION ALL
SELECT	'apple', 2, 2 UNION ALL
SELECT	'orange', 3, 1 UNION ALL
SELECT	'orange', 1, 1 UNION ALL
SELECT	'apple', 2, 2

SELECT		Status,
		SUM(Number) AS Number,
		Month
FROM		(
			SELECT		Status,
					COUNT(*) AS Number,
					Month
			FROM		@Sample
			GROUP BY	Status,
					Month

			UNION ALL

			SELECT		s.Status,
					0,
					v.Number
			FROM		@Sample AS s
			INNER JOIN	master..spt_values AS v ON v.Type = 'P'
			WHERE		v.Number BETWEEN 1 AND 12
			GROUP BY	s.Status,
					v.Number
		) AS d
GROUP BY	Status,
		Month
ORDER BY	Status,
		Month