题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
select order_date ,a.user_id ,order_nums ,vip from ( select user_id ,date_format(order_time,'%Y-%m-%d') order_date ,count(order_id) order_nums from order_tb group by 1,2 having order_nums > 1 )a join uservip_tb on a.user_id = uservip_tb.user_id order by order_nums desc