题解 | 淘宝店铺的实际销售额与客单价
淘宝店铺的实际销售额与客单价
https://www.nowcoder.com/practice/ce116419a1f141568094b5eab70e5ce8
SELECT
ROUND(SUM(s.sales_num*g.goods_price),3) AS sales_total,
ROUND(SUM(s.sales_num*g.goods_price)/COUNT(DISTINCT s.user_id),3) AS per_trans
FROM
sales_tb AS s
INNER JOIN
goods_tb AS g ON s.goods_id=g.goods_id
查看18道真题和解析
海康威视公司福利 1198人发布