题解 | 淘宝店铺的实际销售额与客单价
select
round(sum(sales_num * goods_price), 3) sales_total,
round(
sum(sales_num * goods_price) / count(distinct user_id),
3
) per_trans
from
sales_tb st
join goods_tb gt on st.goods_id = gt.goods_id