Find 3 or More Consecutive Unbooked Seats in SQL | Seating Arrangement Query Explained

You're given a seating layout in SQL, and you want to find 3 or more consecutive unbooked seats. This is a real-world problem in ticket booking systems (airlines, trains, cinemas) and tests your SQL logic and pattern-matching skills.

Write a SQL query to return all sequences where 3 or more consecutive seats are unbooked (is_booked = 0).

🔍 What You'll Learn in This Video:

How to identify consecutive patterns using SQL

Use of ROW_NUMBER() and gaps-and-islands technique

How to group unbooked rows into streaks

Filtering only streaks with 3 or more consecutive unbooked seats

💡 This logic can be applied to many real-world systems:

Ticketing apps

Movie seat booking

Airline or train reservations

Hotel room allocations

Видео Find 3 or More Consecutive Unbooked Seats in SQL | Seating Arrangement Query Explained канала SQLCodeClarity