题解 | 淘宝店铺的实际销售额与客单价
淘宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/ce116419a1f141568094b5eab70e5ce8
select sum(sales_total), round(sum(sales_total)/user_num, 3) as per_trans
from (
select goods_price*sales_num as sales_total,
(select count(distinct user_id) from sales_tb) as user_num
from sales_tb a join goods_tb b on a.goods_id=b.goods_id
)
temp
投递海尔等公司10个岗位
查看6道真题和解析