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

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