题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
select date(order_time)order_date,o.user_id,count(order_id)order_nums,vip from order_tb o join uservip_tb u using(user_id) group by date(order_time),o.user_id,vip having count(order_id) >1 order by order_nums desc; 我终于想起来用having而不是where了哈哈
查看21道真题和解析