题解 | #某宝店铺的实际销售额与客单价#
某宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/b3a0731dfd654361943916d8d85699cd
SELECT sales_total, round(sales_total/count_user,2) FROM(select sum(sales_price) as sales_total,COUNT(DISTINCT user_id) AS count_user from sales_tb) AS a