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

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;