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

select
    round(sum(sales_num * goods_price), 3) sales_total,
    round(
        sum(sales_num * goods_price) / count(distinct user_id),
        3
    ) per_trans
from
    sales_tb
    join goods_tb using (goods_id)