Sequence Puzzle | SQL Scenario interview question (Amazon data engineering interview)

DML Script: datasculptor.blogspot.com/202...

[@ChandrashekarReddyY-hp4rl]

Amazing Content

[@MusicalShorts-hn1px]

Thanks ! Keep posting more such problems

[@datasculptor2895]

Thanks. Will do

[@kra1071]

Seems like a good question sir. Thanks for sharing

[@datasculptor2895]

Thanks. Please like share and subscribe to my channel 🙏

[@DE_Pranav]

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