SQL ülesanded: AB Aviafirma

CREATE TABLE Company(
ID_comp int PRIMARY KEY AUTO_INCREMENT,
name char(10)
);
CREATE TABLE Trip (
trip_no int primary key auto_increment,
ID_comp int,
FOREIGN KEY (ID_comp) REFERENCES company(ID_comp),
plane char(10),
town_from char(25),
town_to char(25),
time_out datetime,
time_in datetime
)

CREATE TABLE Passenger(
ID_psg int PRIMARY key AUTO_INCREMENT,
name char(20)
);
CREATE TABLE Pass_in_trip(
trip_no int,
FOREIGN KEY (trip_no) REFERENCES Trip(trip_no),
date_ datetime,
ID_psg int,
FOREIGN KEY (ID_psg) REFERENCES Passenger(ID_psg),
place char(10),
primary key (trip_no, date_, ID_psg)
);

INSERT INTO passenger(name) VALUES ("Dmitri");
INSERT INTO passenger(name) VALUES ("Darja");
INSERT INTO passenger(name) VALUES ("Aleksander");
INSERT INTO passenger(name) VALUES ("Nikita");
INSERT INTO passenger(name) VALUES ("Josef");

INSERT INTO Company(name) VALUES ("AirGo");
INSERT INTO Company(name) VALUES ("BalticAir");
INSERT INTO Company(name) VALUES ("SwedenPlanes");
INSERT INTO Company(name) VALUES ("PlaneGo");
INSERT INTO Company(name) VALUES ("EuropaAirLines");

INSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES ("Douglas B-18 Bolo", "Tallinn", "Berlin",  "2023-3-13 10:30:00", "2023-3-13 14:30:00");
INSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES ("F-35", "Washington", "Baghdad",  "2023-3-13 17:30:00", "2023-3-13 23:00:00");
INSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES ("Airbus 535", "Moscow", "Pekin",  "2023-3-20 8:10:00", "2023-3-20 16:00:00");
INSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES ("Boeing 777", "Stockholm", "Berlin",  "2023-4-2 5:30:00", "2023-4-2 8:45:00");
INSERT INTO trip(plane, town_from, town_to, time_out, time_in) VALUES ("Iljušin Il-76", "Magadan", "Tokio",  "2023-5-5 12:10:00", "2023-5-5 16:00:00");

INSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES ("35F", "2023-5-5 12:10:00", 2, 2);
INSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES ("1F", "2023-03-13 10:30:00", 1, 1);
INSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES ("5F", "2023-03-20 08:10:00", 3, 3);
INSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES ("6F", "2023-04-02 05:30:00", 4, 4);
INSERT INTO pass_in_trip(place, date_,trip_no, ID_psg) VALUES ("44B", "2023-05-05 12:10:00", 5, 5);