SELECT
concat(
date_format(
date_add(
date( inst_time ),
INTERVAL 1-if (
date_format( date( inst_time ), '%w' )= 0,
7,
date_format( date( inst_time ), '%w' )) DAY
),
'%Y-%m-%d'
),
' TO ',
date_format(
date_add(
date( inst_time ),
INTERVAL 7-if (
date_format( date( inst_time ), '%w' )= 0,
7,
date_format( date( inst_time ), '%w' )) DAY
),
'%Y-%m-%d'
)) AS RegWeek,#RegWeek可以自己按业务内容修改
COUNT('REGIST_NO') as RegNum#REGIST_NO、RegNum可以自己按业务内容修改
FROM table1#table1可以自己按业务内容修改
WHERE INST_TIME between '2021-12-08' and '2022-03-08'#INST_TIME可以自己按业务内容修改
GROUP BY RegWeek
ORDER BY RegWeek DESC
1