select sum(sales_total), round(sum(sales_total)/user_num, 3) as per_trans
from (
    select goods_price*sales_num as sales_total,
    (select count(distinct user_id) from sales_tb) as user_num
    from sales_tb a join goods_tb b on a.goods_id=b.goods_id
)
temp