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

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