题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
select order_date,t1.user_id,order_nums,vip from uservip_tb left join ( select user_id,count(order_date) order_nums,order_date from( select user_id , date(order_time) as order_date from order_tb group by user_id,order_time ) t group by user_id,order_date )t1 on t1.user_id = uservip_tb.user_id where order_nums > 1
查看15道真题和解析
你只是陷入了短暂的低谷，你也一直有退路