题解 | 查询单日多次下订单的用户信息？
select date(order_time) order_date ,o.user_id ,count(date(order_time)) order_nums ,u.vip from order_tb o left join uservip_tb u on o.user_id=u.user_id group by user_id,date(order_time) having count(date(order_time))>1 order by order_nums desc
快手公司福利 313人发布
查看4道真题和解析
投递拼多多集团-PDD等公司10个岗位 >
