题解 | 淘宝店铺的实际销售额与客单价

select round(sum(s.sales_num*g.goods_price),3) as sales_total,
round(sum(s.sales_num*g.goods_price)/count(distinct s.user_id),3) as per_trans
from sales_tb s
join goods_tb g
on s.goods_id = g.goods_id

简单