题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
select date(order_time) order_date, o.user_id, count(order_id) order_nums, vip from order_tb o join uservip_tb u on o.user_id = u.user_id group by order_date,user_id having order_nums > 1
投递字节跳动等公司10个岗位