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