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

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