select * from tb
union all
select null,null,sum(销售量),店铺 from tb group by 店铺

------解决方案--------------------
SQL code
 SELECT 销售量from tb where 店铺名='A' and 日期=datepart (y,getdate())
SELECT 销售量from tb where 店铺名='B' and 日期=datepart (y,getdate())
SELECT 销售量from tb where 店铺名='C' and 日期=datepart (y,getdate())
SELECT 销售量from tb where 店铺名='D' and 日期=datepart (y,getdate())

------解决方案--------------------
SQL code
  SELECT SUM(销售量) from tb where 店铺名='A' and 日期=datepart (y,getdate())
SELECT SUM(销售量) from tb where 店铺名='B' and 日期=datepart (y,getdate())
SELECT SUM(销售量) from tb where 店铺名='C' and 日期=datepart (y,getdate())
SELECT SUM(销售量) from tb where 店铺名='D' and 日期=datepart (y,getdate())

------解决方案--------------------
SQL code
select * from tb
union all
select null,null,sum(销售量),店铺 from tb group by 店铺