Notes

CREATE TABLE Passenger (
passenger_id INT PRIMARY KEY,
passenger_name VARCHAR(255),
phone_number VARCHAR(15),
flight_number VARCHAR(10),
flight_name VARCHAR(255),
date_of_arrival DATE,
date_of_departure DATE
);


CREATE TABLE Travel (
agent_id INT PRIMARY KEY,
agent_name VARCHAR(255),
agent_city VARCHAR(255),
booking_assignment VARCHAR(255),
passenger_id INT,
);
INSERT INTO Passenger (passenger_id, passenger_name, phone_number, flight_number, flight_name, date_of_arrival, date_of_departure)
VALUES
(1, 'Sam Smith', '123-456-7890', 'FL123', 'Flight One', '2023-11-15', '2023-11-20'),
(2, 'Sara Johnson', '987-654-3210', 'FL456', 'Flight Two', '2023-11-18', '2023-11-25'),
(3, 'John Doe', '555-123-4567', 'FL789', 'Flight Three', '2023-11-22', '2023-11-28'),
(4, 'Sophie Davis', '777-888-9999', 'FL456', 'Flight Two', '2023-11-25', '2023-11-30'),
(5, 'Steven White', '444-555-6666', 'FL123', 'Flight One', '2023-11-28', '2023-12-05'),
(6, 'Alice Green', '111-222-3333', 'FL789', 'Flight Three', '2023-12-01', '2023-12-08'),
(7, 'Scott Miller', '999-888-7777', 'FL456', 'Flight Two', '2023-12-04', '2023-12-10'),
(8, 'Sophia Lee', '666-777-8888', 'FL123', 'Flight One', '2023-12-08', '2023-12-15');
INSERT INTO Travel (agent_id, agent_name, agent_city, booking_assignment, passenger_id)
VALUES
(101, 'TravelCo Agent 1', 'City A', 'Booking-101', 1),
(102, 'TravelCo Agent 2', 'City B', 'Booking-102', 2),
(103, 'TravelCo Agent 3', 'City C', 'Booking-103', 3),
(104, 'TravelCo Agent 4', 'City D', 'Booking-104', 4),
(105, 'TravelCo Agent 5', 'City E', 'Booking-105', 5),
(106, 'TravelCo Agent 6', 'City F', 'Booking-106', 6),
(107, 'TravelCo Agent 7', 'City G', 'Booking-107', 7),
(108, 'TravelCo Agent 8', 'City H', 'Booking-108', 8);

SELECT t.booking_assignment FROM Travel t JOIN Passenger p ON t.passenger_id = p.passenger_id WHERE p.passenger_name LIKE 'S%';
SELECT * FROM Passenger p INNER JOIN Travel t ON p.passenger_id = t.passenger_id;
SELECT * FROM Passenger ORDER BY passenger_id DESC;
SELECT * FROM Travel ORDER BY agent_id DESC;
SELECT p.passenger_id, p.passenger_name, p.flight_number, p.flight_name, t.agent_name FROM Passenger p INNER JOIN Travel t ON p.passenger_id = t.pass