题解 | 淘宝店铺的实际销售额与客单价
淘宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/ce116419a1f141568094b5eab70e5ce8
select
round(sum(total)*1.0,3) as sales_total,
round(sum(total) / count(distinct user_id) * 1.0 , 3)per_trans
from (
select
user_id,
goods_id,
sum(sales_num * goods_price) as total
from sales_tb
join goods_tb using(goods_id)
group by goods_id,user_id
) as u1