Group the ones that are the same and right next to each other in sql

table:






websit_id

updated_at

display_id







1222

03-06 06:00

apple





1222

03-06 08:00

apple





1222

03-06 10:00

carrot





1222

03-06 12:00

apple





1222

03-06 14:00

fig





1234

03-06 06:00

apple





1234

03-06 08:00

peach









I wanted to label the rows so that it groups the same display ID that are right next to each other but would not group them if there's something else in btw.
The desired outcome should be the following:






websit_id

updated_at

display_id

group_label







1222

03-06 06:00

apple

1





1222

03-06 08:00

apple

1





1222

03-06 10:00

carrot

2





1222

03-06 12:00

apple

3





1222

03-06 14:00

fig

4





1234

03-06 06:00

apple

1





1234

03-06 08:00

peach

2









I am using snowflake for this.