请教SQLSERVER汇总问题

//建表

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Shop]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Shop]
GO

CREATE TABLE [dbo].[Shop] (
[Year] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[Month] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[CustomerCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[MaterialCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[StockQty] [int] NULL ,
[Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Qty] [int] NULL ,
[Amount] [decimal](10, 1) NULL ,
[ShopCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

//测试数据
insert into [dbo].[shop]( [Year],[Month],[CustomerCode],[MaterialCode],[StockQty],[Type],[Qty],[Amount],[ShopCode])
values('2008' , '6' ,'XJ0032', 'C182W222003', 26, 'Shop', 22 ,1656.0 ,'SXJ236' )
insert into [dbo].[shop]( [Year],[Month],[CustomerCode],[MaterialCode],[StockQty],[Type],[Qty],[Amount],[ShopCode])
values('2009' , '5' ,'XJ0032', 'C182W222003', 26, 'Shop', 24 ,2656.0 ,'SXJ236' )
insert into [dbo].[shop]( [Year],[Month],[CustomerCode],[MaterialCode],[StockQty],[Type],[Qty],[Amount],[ShopCode])
values('2008' , '8' ,'X