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