Скачать или смотреть Leetcode MEDIUM 2783 - Flight Occupancy & Waitlist - Rolling Count in SQL | Everyday Data Science

Question: https://leetcode.com/problems/flight-...

SQL Schema:
Create table if not exists Flights(flight_id int,capacity int)
Create table if not exists Passengers (passenger_id int,flight_id int)
Truncate table Flights
insert into Flights (flight_id, capacity) values ('1', '2')
insert into Flights (flight_id, capacity) values ('2', '2')
insert into Flights (flight_id, capacity) values ('3', '1')
Truncate table Passengers
insert into Passengers (passenger_id, flight_id) values ('101', '1')
insert into Passengers (passenger_id, flight_id) values ('102', '1')
insert into Passengers (passenger_id, flight_id) values ('103', '1')
insert into Passengers (passenger_id, flight_id) values ('104', '2')
insert into Passengers (passenger_id, flight_id) values ('105', '2')
insert into Passengers (passenger_id, flight_id) values ('106', '3')
insert into Passengers (passenger_id, flight_id) values ('107', '3')

Pandas Schema:
data = [[1, 2], [2, 2], [3, 1]]
flights = pd.DataFrame(data, columns=['flight_id', 'capacity']).astype({'flight_id':'Int64', 'capacity':'Int64'})
data = [[101, 1], [102, 1], [103, 1], [104, 2], [105, 2], [106, 3], [107, 3]]
passengers = pd.DataFrame(data, columns=['passenger_id', 'flight_id']).astype({'passenger_id':'Int64', 'flight_id':'Int64'})

#leetcode #datascience #tutorial