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