题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
select
date(ot.order_time) as order_date,
ot.user_id,
count(*) as order_nums,
ut.vip
from
order_tb ot
inner join uservip_tb ut on ot.user_id = ut.user_id
group by
order_date,
user_id
having
order_nums > 1
order by
order_date,
order_nums desc;
having：分组后条件
查看4道真题和解析
