how to find the employees who have been on the job for 7 consecutive days?

I have a table for employees working days records,

the goal is to find who have been working for consecutive 7 days, the

output is for example:

ID / name / the day / comments

007/James Bond /2025-06-25 / have been working for 7 days

007/James Bond /2025-07-15/ have been working for 7 days

031/ Flora Li / 2025-6-13/ have been working for 7 days

045/ Jack Chen/ 2025-6-08 / have been working for 7 days

I made the group loop start to make them single records orderly,current table is on this step like these, pls support the ideas…