题解 | #某宝店铺的实际销售额与客单价#

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