sql进行周期数据查询

急！
哪位达神知道这个咋写吗 我要查的数据是周四到周三的数据 用的是Clickhouse数据库

img


十分感谢！！

img

表结构是怎样的？

这用上一题的答案稍微改一下不就出来了？

SELECT today() AS o,
 concat(formatDateTime(toStartOfWeek(today() + toIntervalDay(3)) - toIntervalDay(3), '%m-%d') ,'~',
 formatDateTime(toStartOfWeek(today() + toIntervalDay(3)) + toIntervalDay(3), '%m-%d')) AS b1,
 concat(formatDateTime(toStartOfWeek(today() + toIntervalDay(3)) - toIntervalDay(10), '%m-%d') ,'~',
 formatDateTime(toStartOfWeek(today() + toIntervalDay(3)) - toIntervalDay(4), '%m-%d')) AS b2,
 concat(formatDateTime(toStartOfWeek(today() + toIntervalDay(3)) - toIntervalDay(17), '%m-%d') ,'~',
 formatDateTime(toStartOfWeek(today() + toIntervalDay(3)) - toIntervalDay(11), '%m-%d')) AS b3,
 concat(formatDateTime(toStartOfWeek(today() + toIntervalDay(3)) - toIntervalDay(24), '%m-%d') ,'~',
 formatDateTime(toStartOfWeek(today() + toIntervalDay(3)) - toIntervalDay(18), '%m-%d')) AS b4
;

img

给你个官方文档地址吧,想要什么函数可以先在官方文档里找一下