34,575
社区成员
发帖
与我相关
我的任务
分享
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
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
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 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