题解 | 查询单日多次下订单的用户信息？

select 
  order_date,
  a.user_id,
  order_nums,
  vip 
from 
  (
    select 
      user_id,
      date(order_time) as order_date,
      count(user_id) as order_nums
    from 
      order_tb
    group by 
      user_id,
      order_date
    having 
      order_nums >1
  ) as a
left join 
  uservip_tb as b
on 
  a.user_id=b.user_id
order by 
  order_nums desc;