题解 | 淘宝店铺的实际销售额与客单价

select round(sum(a.sales_num*b.goods_price),3) as sales_total,round(sum(a.sales_num*b.goods_price)/count(distinct user_id),3) as per_trans
from sales_tb a
left join goods_tb b on a.goods_id=b.goods_id