select sum(sales_num*goods_price) as sales_total
,sum(sales_num*goods_price)/count(distinct t.user_id) as per_trans
from sales_tb t
join goods_tb t1 on t.goods_id = t1.goods_id 
where date(sales_date) between '2021-12-15' and '2021-12-31'