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

select
    sum(s.sales_num * g.goods_price) 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 using (goods_id)