Try this:
DECLARE @tmp TABLE (a INT, b INT, c INT, [YY] INT, [MM] INT, [DD] INT, [Hr] INT, [Min] INT, [Sec] INT)
INSERT INTO @tmp (a, b, c, [YY], [MM], [DD], [Hr], [Min], [Sec])
SELECT 1080 AS a, 20006 as b, 24122 AS c, 2013 AS [YY], 5 AS [MM], 6 AS [DD], 17 AS [Hr], 8 AS [Min], 1 AS [Sec]
UNION ALL
SELECT 1080, 20006, 24123, 2013, 5, 7, 17, 16, 28
UNION ALL
SELECT 1080, 20006, 24124, 2013, 5, 11, 17, 21, 21
UNION ALL
SELECT 1080, 20006, 24125, 2013, 5, 13, 17, 25, 12
UNION ALL
SELECT 1080, 20007, 24126, 2013, 7, 9, 17, 30, 13
UNION ALL
SELECT 1080, 20007, 24127, 2013, 7, 9, 17, 40, 2
UNION ALL
SELECT 1080, 20007, 24128, 2013, 7, 9, 17, 49, 35
UNION ALL
SELECT 1080, 20007, 24129, 2013, 7, 9, 18, 0, 10
UNION ALL
SELECT 1080, 20008, 24130, 2013, 8, 9, 18, 6, 27
UNION ALL
SELECT 1080, 20008, 24131, 2013, 8, 11, 18, 12, 55
UNION ALL
SELECT 1080, 20009, 24132, 2013, 5, 13, 18, 19, 48
UNION ALL
SELECT 1080, 20009, 24133, 2013, 5, 13, 18, 28, 36
SELECT b, [YY], [MM], [Packet0to10], [Packet11to15], [MoreThan15]
FROM (
SELECT b, [YY], [MM], [PacketName], COUNT([DD]) AS CountOfPackets
FROM (
SELECT b, [YY], [MM], [DD], CASE
WHEN [DD] >=0 AND [DD] <=10 THEN 'Packet0to10'
WHEN [DD] >10 AND [DD] <=15 THEN 'Packet11to15'
ELSE 'MoreThan15' END AS [PacketName]
FROM @tmp
) AS T
GROUP BY b, [YY], [MM], [PacketName]
) AS DT
PIVOT (SUM([CountOfPackets]) FOR [PacketName] IN ([Packet0to10], [Packet11to15], [MoreThan15])) AS PT