题解 | 淘宝店铺的实际销售额与客单价
淘宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/ce116419a1f141568094b5eab70e5ce8
WITH t1 AS (
SELECT
s.goods_id,
sum(sales_num) * max(goods_price) sales
FROM sales_tb s JOIN goods_tb g USING(goods_id)
GROUP BY s.goods_id
)
SELECT
round(sum(t1.sales),3) sales_total,
round(sum(t1.sales)/(SELECT count(DISTINCT user_id) FROM sales_tb),3)
FROM t1
