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