LeetCode SQL Medium

Currently Playing: Leetcode MEDIUM 3140 - Consecutive Available Seats II RANKING SQL - Solved by Everyday Data Science

Question: https://leetcode.com/problems/consecutive-available-seats-ii/description/ SQL Schema: CREATE TABLE if Not exists Cinema ( seat_id INT PRIMARY KEY AUTO_INCREMENT, free BOOLEAN ) Truncate table Cinema insert into Cinema (seat_id, free) values ('1', '1') insert into Cinema (seat_id, free) values ('2', '0') insert into Cinema (seat_id, free) values ('3', '1') insert into Cinema (seat_id, free) values ('4', '1') insert into Cinema (seat_id, free) values ('5', '1') Pandas Schema: data = [[1, 1], [2, 0], [3, 1], [4, 1], [5, 1]] cinema = pd.DataFrame({'seat_id': pd.Series(dtype='int'), 'free': pd.Series(dtype='bool')}) #datascience #mysqltutorials #leetcodesolutions