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

SELECT
    ROUND(SUM(s.sales_num*g.goods_price),3) AS sales_total,
    ROUND(SUM(s.sales_num*g.goods_price)/COUNT(DISTINCT s.user_id),3) AS per_trans
FROM
    sales_tb AS s
    INNER JOIN
    goods_tb AS g ON s.goods_id=g.goods_id