题解 | 淘宝店铺的实际销售额与客单价
淘宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/ce116419a1f141568094b5eab70e5ce8
select
sum(t1.sales_num*t1.goods_price) as sales_total,
sum(t1.sales_num*t1.goods_price) /count(distinct t1.user_id) asper_trans
from(
select *
from sales_tb
left join goods_tb using(goods_id)
) t1
…..