题解 | 淘宝店铺的实际销售额与客单价
淘宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/ce116419a1f141568094b5eab70e5ce8
select round(sum(sales_num*goods_price),3) as sales_total, round(sum(sales_num*goods_price)/count(distinct user_id),3) as per_trans from sales_tb s join goods_tb g on s.goods_id=g.goods_id
查看19道真题和解析