The Number of Passengers in Each Bus II
[]
['Create table If Not Exists Buses (bus_id int, arrival_time int, capacity int)', 'Create table If Not Exists Passengers (passenger_id int, arrival_time int)', 'Truncate table Buses', "insert into Buses (bus_id, arrival_time, capacity) values ('1', '2', '1')", "insert into Buses (bus_id, arrival_time, capacity) values ('2', '4', '10')", "insert into Buses (bus_id, arrival_time, capacity) values ('3', '7', '2')", 'Truncate table Passengers', "insert into Passengers (passenger_id, arrival_time) values ('11', '1')", "insert into Passengers (passenger_id, arrival_time) values ('12', '1')", "insert into Passengers (passenger_id, arrival_time) values ('13', '5')", "insert into Passengers (passenger_id, arrival_time) values ('14', '6')", "insert into Passengers (passenger_id, arrival_time) values ('15', '7')"]
{"mysql": ["Create table If Not Exists Buses (bus_id int, arrival_time int, capacity int)", "Create table If Not Exists Passengers (passenger_id int, arrival_time int)"], "mssql": ["Create table Buses (bus_id int, arrival_time int, capacity int)", "Create table Passengers (passenger_id int, arrival_time int)"], "oraclesql": ["Create table Buses (bus_id int, arrival_time int, capacity int)", "Create table Passengers (passenger_id int, arrival_time int)"], "database": true, "name": "number_of_passengers", "pythondata": ["Buses = pd.DataFrame([], columns=['bus_id', 'arrival_time', 'capacity']).astype({'bus_id':'Int64', 'arrival_time':'Int64', 'capacity':'Int64'})", "Passengers = pd.DataFrame([], columns=['passenger_id', 'arrival_time']).astype({'passenger_id':'Int64', 'arrival_time':'Int64'})"], "postgresql": ["Create table If Not Exists Buses (bus_id int, arrival_time int, capacity int)", "Create table If Not Exists Passengers (passenger_id int, arrival_time int)"], "database_schema": {"Buses": {"bus_id": "INT", "arrival_time": "INT", "capacity": "INT"}, "Passengers": {"passenger_id": "INT", "arrival_time": "INT"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']