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