题解 | 查询单日多次下订单的用户信息？
select substr(t1.order_time,1,10) as order_date ,t1.user_id ,count(1) as order_nums ,t2.vip as vip from order_tb t1 left join uservip_tb t2 on t1.user_id = t2.user_id group by user_id,substr(order_time,1,10) having count(1) > 1 order by order_nums desc;
