select
date(order_time) as  order_date
,user_id
,count(order_id) as order_nums
,vip	
from uservip_tb
join order_tb
using(user_id)
group by 1,2
having count(order_nums) >1 
order by 3 desc

这道题需要注意是单日单用户，所以是group by 日期，用户，而非单纯对用户聚合