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