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