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

with
t1 as(
    select
        sum(sales_num*goods_price),
        sum(sales_num*goods_price)/count(distinct user_id)
    from
        sales_tb left join goods_tb using(goods_id)
)

select * from t1