题解 | SQL 181. 某宝店铺的实际销售额与客单价
某宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/b3a0731dfd654361943916d8d85699cd
WITH t1 AS (
SELECT
SUM(sales_price) AS sales_total,
ROUND(
SUM(sales_price)
/
COUNT(DISTINCT user_id)
,
2) AS per_trans
FROM sales_tb
)
SELECT * FROM t1;
