题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
select distinct substring(o.order_time,1,10) order_date, o.user_id,count(o.order_time) order_nums, v.vip from order_tb o left join uservip_tb v on o.user_id = v.user_id group by substring(order_time,1,10),o.user_id,v.vip having count(o.order_time) > 1 order by order_nums desc
