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

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