题解 | #某宝店铺的实际销售额与客单价#
某宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/b3a0731dfd654361943916d8d85699cd
select SUM(sales_price) as sales_total, CAST(SUM(sales_price)/COUNT(DISTINCT(user_id)) as decimal(10,2)) as per_trans from sales_tb
某宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/b3a0731dfd654361943916d8d85699cd
select SUM(sales_price) as sales_total, CAST(SUM(sales_price)/COUNT(DISTINCT(user_id)) as decimal(10,2)) as per_trans from sales_tb
相关推荐