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

select substr(o.order_time,1,10) as order_date,o.user_id,
count(o.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
having order_nums>1
order by order_nums desc

简单