SELECT
DATE_SUB('2023-07-01',INTERVAL WEEKDAY('2023-07-01') DAY) as firstDay,
DATE_ADD('2023-07-01',INTERVAL 6-WEEKDAY('2023-07-01') DAY) as lastDay,
DATE_ADD('2023-07-01',INTERVAL 7-WEEKDAY('2023-07-01') DAY) as nextFirstDay,
DATE_ADD('2023-07-01',INTERVAL 13-WEEKDAY('2023-07-01') DAY) as nextLasttDay;