题解 | 查询单日多次下订单的用户信息？
select
date_format (order_time, '%Y-%m-%d') as order_date,
o.user_id as user_id,
count(order_id) as order_nums,
u.vip as vip
from
order_tb o,
uservip_tb u
where
o.user_id = u.user_id
group by
o.user_id,
order_date
having
order_nums > 1
order by
order_nums desc