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

select date(order_time) as order_date, o.user_id, count(order_time) as order_nums, u.vip
from order_tb o
join uservip_tb u
on o.user_id=u.user_id
group by order_date, o.user_id, vip
having order_nums > 1;