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

select
        sum(sales_num * goods_price) as sales_total,
        sum(sales_num * goods_price)/count(distinct user_id) as per_trans
from 
        sales_tb as st
left join 
        goods_tb as gt
on 
        st.goods_id  = gt.goods_id