题解 | 查询单日多次下订单的用户信息?
查询单日多次下订单的用户信息?
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
select date(order_time) as order_date ,user_id ,count(*) as order_nums ,vip from order_tb join uservip_tb using(user_id) group by order_date,user_id having order_nums > 1 order by order_nums desc