select date(order_time) order_date	
,order_tb.user_id
,count(order_id) order_nums
,vip
from order_tb
left join uservip_tb
on order_tb.user_id = uservip_tb.user_id
group by 1,2,4
having count(order_id)>=2