题解 | 淘宝店铺的实际销售额与客单价
淘宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/ce116419a1f141568094b5eab70e5ce8
select
round(price_sum * 1.0, 3) sales_total
,round(price_sum / num * 1.0, 3) per_trans
from(
select
sum(sales_num) sales_sum
,sum(sales_num * goods_price) price_sum
,count(distinct user_id) num
from sales_tb s
join goods_tb g
on s.goods_id = g.goods_id
) t
查看17道真题和解析