一个SQL问题，麻烦帮个忙，谢谢

create table Goods(
goodsname varchar(20)
)
create table Sale(
goodsname varchar(20),
salequantity int,
saletype varchar(10)
)
insert into Goods values('可乐')
insert into Goods values('雪碧')
insert into Goods values('百事')
insert into Sale values('可乐',1,'A')
insert into Sale values('可乐',2,'B')
insert into Sale values('百事',1,'C')
insert into Sale values('百事',1,'A')
select *
from Goods
select c.goodsname as '商品名称',c.cou as '销售数量',isnull(d.salequantity,0) as 'A',isnull(e.salequantity,0) as 'B',isnull(f.salequantity,0) as 'C'
from (select a.goodsname,isnull(sum(salequantity),0) as cou
from Goods a
left outer join sale b on a.goodsname=b.goodsname
group by a.goodsname) c
left outer join sale d on c.goodsname=d.goodsname and d.saletype='A'
left outer join sale e on c.goodsname=e.goodsname and e.saletype='B'
left outer join sale f on c.goodsname=f.goodsname and f.saletype='C'

以上是建表语句，查询语句和查询结果 @青石上的蚂蚁V

select c.goodsname as '商品名称',c.cou as '销售数量',isnull(d.salequantity,0) as 'A',isnull(e.salequantity,0) as 'B',isnull(f.salequantity,0) as 'C'
from (select a.goodsname,isnull(sum(salequantity),0) as cou
from Goods a
left outer join sale b on a.goodsname=b.goodsname
group by a.goodsname) c
left outer join sale d on c.goodsname=d.goodsname and d.saletype='A'
left outer join sale e on c.goodsname=e.goodsname and e.saletype='B'
left outer join sale f on c.goodsname=f.goodsname and f.saletype='C'
上边是查询语句
这句
select *
from Goods
没有用