with cte(회사, 갯수, 년도)
as (
select 'A', '1', '2006' union all
select 'A','8','2007' union all
select 'A','3','1900' union all
select 'B', '1','2007' union all
select 'B','1','2008' union all
select 'B','1','2010' union all
select 'B','8','2012' union all
select 'C','1','2006' union all
select 'C','13','2007' union all
select 'C','17','2008' union all
select 'C','2','2009' union all
select 'C','1','2010' union all
select 'C','11','2011' union all
select 'D', '1', '2011' union all
select 'D', '42', '2012' union all
select 'E', '1', '2009' union all
select 'E', '1', '2010' union all
select 'E', '1', '2011' union all
select 'E', '3', '1900'
)
select
 회사,
 SUM(cast(갯수 as int)) as [합계],
 sum(case when 년도 = 2012 then 갯수 else 0 end) as [2012]  ,
 sum(case when 년도 = 2011 then 갯수 else 0 end) as [2011]  ,
 sum(case when 년도 = 2010 then 갯수 else 0 end) as [2010]  ,
 sum(case when 년도 = 2009 then 갯수 else 0 end) as [2009]  ,
 SUM(CASE WHEN 년도 NOT IN (2012, 2011, 2010, 2009) THEN 갯수 ELSE 0 END) AS [기타]
 
from cte
group by 회사