34,575
社区成员
发帖
与我相关
我的任务
分享
select p.pub_name,(t.price*t.ytd_sales) from titles t,publishers p where p.pub_id=t.pub_id
select p.pub_name,sum(t.price*t.ytd_sales)
from titles t,publishers p
where p.pub_id=t.pub_id
group by p.pub_name
select
a.pub_name,(b.price*b.ytd_sales) as 总销售额
from
Publisher a join Titles b on
a.pub_id=b.pub_id