sql 计算商品的收入

[pdsnet]

select distinct a.Itemid,a.ItemName ,sum(b.ItemSalenum)as 数量,count(b.itemid) as 次数,
sum(a.Itemprice)as 收入
from Item as a left join
ItemRecord as b on a.itemid=b.Itemid group by a.itemid ,a.ItemName
这是我写的代码 我现在 想要的是 把 商品的收入计算出来， sum(a.Itemprice)as 收入 中间要* 的是 卖出的次数 。count(b.itemid) as 次数,
这个是 算出的次数 ， sum(a.Itemprice*count(b.itemid))as 没有这样的用法 。 这个销售数量是从 商品销售表中 计算出来的 。
id , name ,time(卖出日期)，totel(买出的个数) 急！！！！！！！！！！！！！！

[liangCK]

sum(a.itemprice)*count(b.itemid)

[dawugui]

select a.Itemid,a.ItemName ,sum(b.ItemSalenum) as 数量,count(b.itemid) as 次数, sum(a.Itemprice) as 收入,sum(a.Itemprice*count(b.itemid))
from Item as a left join ItemRecord as b 
on a.itemid=b.Itemid 
group by a.itemid ,a.ItemName  

[dawugui]

select a.Itemid,a.ItemName ,sum(b.ItemSalenum) as 数量,count(b.itemid) as 次数, sum(a.Itemprice) as 收入,sum(a.Itemprice)*count(b.itemid)
from Item as a left join ItemRecord as b 
on a.itemid=b.Itemid 
group by a.itemid ,a.ItemName  

[-狙击手-]

select distinct a.Itemid,a.ItemName ,sum(b.s_items)as 数量,sum(a.Itemprice*b.cnt)as  收入 , 
sum(a.Itemprice)as 收入 
 from Item as a left join  
(select itemid,count(*) as cnt,sum(itemsalenum) as s_items from ItemRecord group by itemid) as b on a.itemid=b.Itemid 
group by a.itemid ,a.ItemName  

[wzy_love_sly]

直接乘结果因该不对吧

[Herb2]

数量×单价，还是次数×单价，应该是这样吧

select distinct a.Itemid,a.ItemName ,sum(b.ItemSalenum)as 数量,count(b.itemid) as 次数, 
sum(a.Itemprice*b.ItemSalenum)as 收入 
 from Item as a left join  
 ItemRecord as b on a.itemid=b.Itemid group by a.itemid ,a.ItemName  

[pdsnet]

要的就是这个效果...谢谢

[zccmy22]

sum(a.Itemprice)*count(b.itemid)