2、查询订单信息表(order_info)中最少连续3天下单的用户id,期望结果如下 订单信息表:order_info 代码 select distinct user_id from ( select user_id ,date1 ,case when (datediff(date2,date1)=1 and datediff(date3,date2)=1 and datediff(date3,date1)=2) then 1 else 0 end diff from ( selec...