leetcode/problems/the-number-of-passengers-in-each-bus-ii/mysql_schemas.sql at main · awesee/leetcode · GitHub

Name: leetcode/problems/the-number-of-passengers-in-each-bus-ii/mysql_schemas.sql at main · awesee/leetcode · GitHub
Rating: 4.5 (2010 reviews)
1
2
3
4
5
6
7
8
9
10
11
12
CreatetableIf Not Exists Buses (bus_id int, arrival_time int, capacity int);
CreatetableIf 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');