06.统计2020年1月到6月，每个品类有多少人购买，累计金额是多少.sql

select goods_category,
		count(distinct user_name) as user_num,
		sum(pay_amount) as total_amount,
from user_trade
where dt between "2020-01-01" and "2020-06-30"
group by goods_category;