It will work with COUNT in place of ROW_NUMBER

Seems like a good question sir. Thanks for sharing

Thanks ! Keep posting more such problems

Amazing Content

select name, min(sequence)[min], max(sequence)[max] from (select *, sequence-ROW_NUMBER() over (partition by name order by sequence) as grp from SequenceData)a group by name,grp