Detailed notes for this lesson are being written. They appear here together with the video.
Video coming soonThis lesson’s video is being made
Start with the notes below; the video appears here as soon as it is on YouTube.
SQL and Databases · Lesson 82 of 90
SQL interview 5: consecutive days, streaks and gaps
consecutive login dayslongest streakconsecutive numbers (3 in a row)missing IDsgaps-and-islands interview patternLAG-based break detection