题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
select date(a.order_time) order_date,a.user_id,count(*) order_nums,b.vip from order_tb a join uservip_tb b on a.user_id =b.user_id group by date(a.order_time),a.user_id,b.vip having order_nums>1 order by order_nums desc
小天才公司福利 1874人发布