SELECT
case when [defragDate] IS NOT NULL THEN 1 ELSE 0 END AS 'Defrag',
SUM (case when fragmentation >= 90 then 1 else 0 end) AS 'Count>=90',
SUM (case when fragmentation >= 90 then page_count else 0 end) AS 'PageCount >=90',
SUM (case when fragmentation >= 80 AND fragmentation < 90 then 1 else 0 end ) AS 'Count>=80',
SUM (case when fragmentation >= 80 AND fragmentation < 90 then page_count else 0 end ) AS 'PageCount >=80',
SUM(case when fragmentation >= 70 AND fragmentation < 80 then 1 else 0 end ) AS 'Count>=70',
SUM(case when fragmentation >= 70 AND fragmentation < 80 then page_count else 0 end ) AS 'PageCount >=70',
SUM(case when fragmentation >= 60 AND fragmentation < 70 then 1 else 0 end ) AS 'Count>=60',
SUM(case when fragmentation >= 60 AND fragmentation < 70 then page_count else 0 end ) AS 'PageCount >=60',
SUM(case when fragmentation >= 50 AND fragmentation < 60 then 1 else 0 end ) AS 'Count>=50',
SUM(case when fragmentation >= 50 AND fragmentation < 60 then page_count else 0 end ) AS 'PageCount >=50',
SUM(case when fragmentation >= 40 AND fragmentation < 50 then 1 else 0 end ) AS 'Count>=40',
SUM(case when fragmentation >= 40 AND fragmentation < 50 then page_count else 0 end ) AS 'PageCount >=40',
SUM(case when fragmentation >= 30 AND fragmentation < 40 then 1 else 0 end ) AS 'Count>=30',
SUM(case when fragmentation >= 30 AND fragmentation < 40 then page_count else 0 end ) AS 'PageCount >=30',
SUM(case when fragmentation >= 20 AND fragmentation < 30 then 1 else 0 end ) AS 'Count>=20',
SUM(case when fragmentation >= 20 AND fragmentation < 30 then page_count else 0 end ) AS 'PageCount >=20',
SUM(case when fragmentation >= 10 AND fragmentation < 20 then 1 else 0 end ) AS 'Count>=10',
SUM(case when fragmentation >= 10 AND fragmentation < 20 then Page_count else 0 end ) AS 'PageCount >=10',
SUM(case when fragmentation >= 0 AND fragmentation < 10 then Page_count else 0 end ) AS 'Count>=0',
SUM(case when fragmentation >= 0 AND fragmentation < 10 then Page_count else 0 end ) AS 'PageCount >=0'
FROM [Temporary].[dbo].[dba_indexDefragStatus]
where databasename = '[corestore]'
and scandate = '2010-05-09 15:00:02.247'
GROUP BY case when [defragDate] IS NOT NULL THEN 1 ELSE 0 END