数查看据集是第二张图显示的样子,想要把跨年的一周汇总在一起,怎么解决呢?concat(case when DATEDIFF(trunc(add_months(date_sub(next_day(DATA_order_PAYMENT,'MO'),interval 7 day),'MM'),date_sub(next_day(DATA_order_PAYMENT,'MO'),interval 7 day))>3 then year(date_sub(next_day(DATA_order_PAYMENT, 'MO'), interval 7 day )) else year(next_day(DATA_order_PAYMENT, 'SU')) end, '年', case when weekofyear(DATA_order_PAYMENT) > 9 then weekofyear(DATA_order_PAYMENT) else concat('0', weekofyear(DATA_order_PAYMENT)) end, '周') as 周,