题解 | #某宝店铺的实际销售额与客单价#
某宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/b3a0731dfd654361943916d8d85699cd
select sum(every_people_money) as sales_total,
round(sum(every_people_money)/count(user_id), 2) as per_trans
from (
select user_id, sum(sales_price) as every_people_money
from sales_tb
group by user_id
) as a;
