Leet Code SQL Problem | Consecutive Seats in Cinema | Data Analytics #sqlinterviewquestions #sql

In this video we will discuss SQL query step by step:-

1.SQL Interview Questions

2.SQL Basic

3.SQL Advance Concept

4. Tableau

5. Python Tutorial

Script:-
create table Cinema(
Seat_id int,
Free_Seat int
);

insert into Cinema values(1,1),
(2,0),
(3,1),
(4,1),
(5,1);

[faisalahmed]

mam solution is not good, you should use instead os doing union between 2 output. it will be more optimised and a better solution.