with t as ( select order_id, hour (event_time) h ,case when hour (event_time) between 7 and 8 then '早高峰' when hour (event_time) between 9 and 16 then '工作时间' when hour (event_time) between 17 and 19 then '晚高峰' else '休息时间' end as period, timestampdiff (second, event_time, order_time) wait, timestampdi...