题解 | 淘宝店铺的实际销售额与客单价
淘宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/ce116419a1f141568094b5eab70e5ce8
with
t1 as (
select
user_id,
sales_num * goods_price sales
from
sales_tb s
left join goods_tb g on s.goods_id = g.goods_id
)
select
round(sum(sales), 3) sales_total,
round(sum(sales) / count(distinct user_id), 3) per_trans
from
t1
360集团二面32人在聊
查看5道真题和解析
，这工资还不如去摇奶茶
投递蚂蚁集团等公司8个岗位 >