with m1 as ( #基础数据表基 select td.order_id,td.rider_id, pickup_time, deliver_time,reg_date,status, case when timestampdiff(day,reg_date,pickup_time) between 0 and 6 then 'W0' when timestampdiff(day,reg_date,pickup_time) between 7 and 13 then 'W1' when timestampdiff(day,reg_date,pickup_time) between 14 ...