FAANG-Style SQL Interview Question | Consecutive Months Streak Challenge

Can you spot customers who kept buying for three months in a row?
This isn’t just a random puzzle - it’s a classic SQL interview pattern called “gaps and islands” that companies like Amazon and Meta love using to test how you handle time-based logic. Most people have only seen the login-streak version. In this video, I take a completely new business scenario and walk through it live inside SQLNest.

My Live SQL Bootcamp is back - the first one in over a year! 8 live sessions, Beginner to Advanced, starting Sept 5. Seats are limited ????
https://sqlnest.com/bootcamp/Live_SQL_Bootcamp_Beginner_to_Advanced


Try it yourself before watching
This exact question is available on SQLNest. Pause the video, give it a serious attempt, and then come back to see how I break it down step by step.
Solve it here: https://sqlnest.com/


Want more problems like this?
SQLNest has hands-on SQL courses, real interview-style questions, and case studies to help you move from just writing queries to thinking like a data professional.
Start here: https://sqlnest.com/


Follow me for more SQL, Data Engineering, and interview prep content:
LinkedIn: /thoufiq-mohammed
Instagram: /techtfq

#SQL #SQLInterview...