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

计算总的，不用分组