I have a data set of fruits. Need to find the consecutive of 3 or more fruit.

select *, row_number() over (partition by fruit_name order by _id) rn from fruit_info

order by _id

but not getting the required output.

Question for question please click the fiddle hyperlink.

Output

Thank you