题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
with
o as (
select
user_id,
date (order_time) as order_date,
count(*) as order_nums
from
order_tb
group by
user_id,
date (order_time)
)
select order_date,o.user_id,order_nums,vip
from o join uservip_tb u on o.user_id=u.user_id where order_nums>1
查看30道真题和解析