题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
select distinct date_format(o.order_time,'%Y-%m-%d') as order_date,
o.user_id as user_id,
count(o.order_time) as order_nums,
u.vip as vip
from order_tb as o
left join uservip_tb as u on o.user_id = u.user_id
group by o.user_id, order_date
having order_nums > 1
查看10道真题和解析
，海投就行了