题目:请你统计实际总销售额与客单价(人均付费,总收入/总用户数,结果保留两位小数)
- 销售额:SUM(sales_price)
- 客单价:SUM(sales_price)/COUNT(DISTINCT user_id)
SELECT SUM(sales_price) sales_total, ROUND(SUM(sales_price)/COUNT(DISTINCT user_id),2) per_trans FROM sales_tb;