SELECT sum(sales_num*goods_price) AS sales_total, 
    sum(sales_num*goods_price)/count(DISTINCT user_id) AS per_trans
FROM sales_tb
JOIN goods_tb
USING(goods_id)