select * from userbehavior_new;
select user_id,max(amount) 最大金额,min(amount) 最小金额,count(*) 消费次数,sum(amount) 消费总额
from userbehavior_new
where behavior_type = 'buy'
group by user_id
order by sum(amount) desc;