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

SELECT
    SUM(st.sales_num * gt.goods_price) sales_total,
    SUM(st.sales_num * gt.goods_price)/COUNT(DISTINCT user_id) per_trans
FROM sales_tb st
JOIN goods_tb gt ON st.goods_id = gt.goods_id